Dataset statistics
| Number of variables | 40 |
|---|---|
| Number of observations | 4882 |
| Missing cells | 8951 |
| Missing cells (%) | 4.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.5 MiB |
| Average record size in memory | 320.0 B |
Variable types
| Numeric | 30 |
|---|---|
| Categorical | 10 |
indfmt has constant value "" | Constant |
consol has constant value "" | Constant |
popsrc has constant value "" | Constant |
datafmt has constant value "" | Constant |
curcd has constant value "" | Constant |
costat has constant value "" | Constant |
datadate has a high cardinality: 121 distinct values | High cardinality |
tic has a high cardinality: 498 distinct values | High cardinality |
cusip has a high cardinality: 498 distinct values | High cardinality |
conm has a high cardinality: 498 distinct values | High cardinality |
gvkey is highly overall correlated with cik | High correlation |
act is highly overall correlated with at and 17 other fields | High correlation |
at is highly overall correlated with act and 16 other fields | High correlation |
bkvlps is highly overall correlated with ceql and 2 other fields | High correlation |
capx is highly overall correlated with act and 15 other fields | High correlation |
ceql is highly overall correlated with act and 16 other fields | High correlation |
csho is highly overall correlated with act and 16 other fields | High correlation |
dltt is highly overall correlated with act and 15 other fields | High correlation |
dt is highly overall correlated with act and 16 other fields | High correlation |
dvp is highly overall correlated with pstkl | High correlation |
ebitda is highly overall correlated with act and 16 other fields | High correlation |
emp is highly overall correlated with act and 12 other fields | High correlation |
lct is highly overall correlated with act and 16 other fields | High correlation |
lt is highly overall correlated with act and 16 other fields | High correlation |
ni is highly overall correlated with act and 15 other fields | High correlation |
ppegt is highly overall correlated with act and 16 other fields | High correlation |
pstkl is highly overall correlated with dvp | High correlation |
revt is highly overall correlated with act and 16 other fields | High correlation |
seq is highly overall correlated with act and 16 other fields | High correlation |
teq is highly overall correlated with act and 16 other fields | High correlation |
xad is highly overall correlated with act and 16 other fields | High correlation |
xrd is highly overall correlated with act | High correlation |
cik is highly overall correlated with gvkey | High correlation |
mkvalt is highly overall correlated with act and 16 other fields | High correlation |
act has 864 (17.7%) missing values | Missing |
bkvlps has 70 (1.4%) missing values | Missing |
csho has 69 (1.4%) missing values | Missing |
dt has 548 (11.2%) missing values | Missing |
ebitda has 264 (5.4%) missing values | Missing |
emp has 71 (1.5%) missing values | Missing |
lct has 860 (17.6%) missing values | Missing |
ppegt has 522 (10.7%) missing values | Missing |
xad has 2720 (55.7%) missing values | Missing |
xrd has 2053 (42.1%) missing values | Missing |
dvpsp_f has 93 (1.9%) missing values | Missing |
mkvalt has 401 (8.2%) missing values | Missing |
prcc_f has 106 (2.2%) missing values | Missing |
bkvlps is highly skewed (γ1 = 47.36237195) | Skewed |
tic is uniformly distributed | Uniform |
cusip is uniformly distributed | Uniform |
conm is uniformly distributed | Uniform |
capx has 309 (6.3%) zeros | Zeros |
dltt has 258 (5.3%) zeros | Zeros |
dt has 237 (4.9%) zeros | Zeros |
dvp has 4213 (86.3%) zeros | Zeros |
pstkl has 4147 (84.9%) zeros | Zeros |
xrd has 651 (13.3%) zeros | Zeros |
dvpsp_f has 1110 (22.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-08 04:16:06.635156 |
|---|---|
| Analysis finished | 2023-05-08 04:17:33.281181 |
| Duration | 1 minute and 26.65 seconds |
| Software version | ydata-profiling vv4.0.0 |
| Download configuration | config.json |
gvkey
Real number (ℝ)
| Distinct | 498 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46174.04 |
| Minimum | 1045 |
|---|---|
| Maximum | 316056 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 1045 |
|---|---|
| 5-th percentile | 2019 |
| Q1 | 6268 |
| median | 12587.5 |
| Q3 | 63172 |
| 95-th percentile | 177267 |
| Maximum | 316056 |
| Range | 315011 |
| Interquartile range (IQR) | 56904 |
Descriptive statistics
| Standard deviation | 61447.241 |
|---|---|
| Coefficient of variation (CV) | 1.3307746 |
| Kurtosis | 1.0336797 |
| Mean | 46174.04 |
| Median Absolute Deviation (MAD) | 9770.5 |
| Skewness | 1.4633294 |
| Sum | 2.2542166 × 108 |
| Variance | 3.7757634 × 109 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 6502 | 11 | 0.2% |
| 11259 | 11 | 0.2% |
| 3813 | 11 | 0.2% |
| 141913 | 11 | 0.2% |
| 9248 | 11 | 0.2% |
| 157855 | 11 | 0.2% |
| 162129 | 11 | 0.2% |
| 165123 | 11 | 0.2% |
| 117768 | 11 | 0.2% |
| 2184 | 11 | 0.2% |
| Other values (488) | 4772 |
| Value | Count | Frequency (%) |
| 1045 | 10 | |
| 1075 | 10 | |
| 1078 | 10 | |
| 1161 | 10 | |
| 1209 | 10 | |
| 1230 | 10 | |
| 1300 | 10 | |
| 1327 | 10 | |
| 1380 | 10 | |
| 1440 | 10 |
| Value | Count | Frequency (%) |
| 316056 | 9 | |
| 294524 | 10 | |
| 260774 | 10 | |
| 189491 | 10 | |
| 187697 | 10 | |
| 187450 | 10 | |
| 186989 | 10 | |
| 186310 | 10 | |
| 185532 | 10 | |
| 184996 | 10 |
datadate
Categorical
| Distinct | 121 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| 2019-12-31 | |
|---|---|
| 2018-12-31 | |
| 2017-12-31 | |
| 2016-12-31 | |
| 2015-12-31 | |
| Other values (116) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 48820 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2010-12-31 |
|---|---|
| 2nd row | 2011-12-31 |
| 3rd row | 2012-12-31 |
| 4th row | 2013-12-31 |
| 5th row | 2014-12-31 |
Common Values
| Value | Count | Frequency (%) |
| 2019-12-31 | 386 | 7.9% |
| 2018-12-31 | 384 | 7.9% |
| 2017-12-31 | 384 | 7.9% |
| 2016-12-31 | 382 | 7.8% |
| 2015-12-31 | 379 | 7.8% |
| 2014-12-31 | 373 | 7.6% |
| 2013-12-31 | 370 | 7.6% |
| 2012-12-31 | 361 | 7.4% |
| 2011-12-31 | 357 | 7.3% |
| 2010-12-31 | 354 | 7.3% |
| Other values (111) | 1152 |
Length
| Value | Count | Frequency (%) |
| 2019-12-31 | 386 | 7.9% |
| 2017-12-31 | 384 | 7.9% |
| 2018-12-31 | 384 | 7.9% |
| 2016-12-31 | 382 | 7.8% |
| 2015-12-31 | 379 | 7.8% |
| 2014-12-31 | 373 | 7.6% |
| 2013-12-31 | 370 | 7.6% |
| 2012-12-31 | 361 | 7.4% |
| 2011-12-31 | 357 | 7.3% |
| 2010-12-31 | 354 | 7.3% |
| Other values (111) | 1152 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 13740 | |
| - | 9764 | |
| 2 | 9149 | |
| 0 | 7030 | |
| 3 | 5435 | 11.1% |
| 9 | 751 | 1.5% |
| 6 | 718 | 1.5% |
| 5 | 592 | 1.2% |
| 8 | 573 | 1.2% |
| 7 | 536 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39056 | |
| Dash Punctuation | 9764 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 13740 | |
| 2 | 9149 | |
| 0 | 7030 | |
| 3 | 5435 | 13.9% |
| 9 | 751 | 1.9% |
| 6 | 718 | 1.8% |
| 5 | 592 | 1.5% |
| 8 | 573 | 1.5% |
| 7 | 536 | 1.4% |
| 4 | 532 | 1.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 9764 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 48820 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 13740 | |
| - | 9764 | |
| 2 | 9149 | |
| 0 | 7030 | |
| 3 | 5435 | 11.1% |
| 9 | 751 | 1.5% |
| 6 | 718 | 1.5% |
| 5 | 592 | 1.2% |
| 8 | 573 | 1.2% |
| 7 | 536 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48820 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 13740 | |
| - | 9764 | |
| 2 | 9149 | |
| 0 | 7030 | |
| 3 | 5435 | 11.1% |
| 9 | 751 | 1.5% |
| 6 | 718 | 1.5% |
| 5 | 592 | 1.2% |
| 8 | 573 | 1.2% |
| 7 | 536 | 1.1% |
fyear
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2014.49 |
| Minimum | 2009 |
|---|---|
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2010 |
| Q1 | 2012 |
| median | 2015 |
| Q3 | 2017 |
| 95-th percentile | 2019 |
| Maximum | 2019 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.8865742 |
|---|---|
| Coefficient of variation (CV) | 0.0014329057 |
| Kurtosis | -1.195576 |
| Mean | 2014.49 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.031825149 |
| Sum | 9834740 |
| Variance | 8.3323106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2017 | 496 | |
| 2018 | 496 | |
| 2016 | 495 | |
| 2015 | 493 | |
| 2014 | 488 | |
| 2013 | 484 | |
| 2012 | 477 | |
| 2019 | 473 | |
| 2011 | 471 | |
| 2010 | 468 |
| Value | Count | Frequency (%) |
| 2009 | 41 | 0.8% |
| 2010 | 468 | |
| 2011 | 471 | |
| 2012 | 477 | |
| 2013 | 484 | |
| 2014 | 488 | |
| 2015 | 493 | |
| 2016 | 495 | |
| 2017 | 496 | |
| 2018 | 496 |
| Value | Count | Frequency (%) |
| 2019 | 473 | |
| 2018 | 496 | |
| 2017 | 496 | |
| 2016 | 495 | |
| 2015 | 493 | |
| 2014 | 488 | |
| 2013 | 484 | |
| 2012 | 477 | |
| 2011 | 471 | |
| 2010 | 468 |
indfmt
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| INDL |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 19528 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | INDL |
|---|---|
| 2nd row | INDL |
| 3rd row | INDL |
| 4th row | INDL |
| 5th row | INDL |
Common Values
| Value | Count | Frequency (%) |
| INDL | 4882 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| indl | 4882 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 4882 | |
| N | 4882 | |
| D | 4882 | |
| L | 4882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 19528 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 4882 | |
| N | 4882 | |
| D | 4882 | |
| L | 4882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19528 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 4882 | |
| N | 4882 | |
| D | 4882 | |
| L | 4882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19528 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 4882 | |
| N | 4882 | |
| D | 4882 | |
| L | 4882 |
consol
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| C |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4882 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | C |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| C | 4882 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| c | 4882 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 4882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4882 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 4882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4882 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 4882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4882 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 4882 |
popsrc
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| D |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4882 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | D |
|---|---|
| 2nd row | D |
| 3rd row | D |
| 4th row | D |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| D | 4882 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| d | 4882 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 4882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4882 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 4882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4882 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 4882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4882 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 4882 |
datafmt
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| STD |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14646 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STD |
|---|---|
| 2nd row | STD |
| 3rd row | STD |
| 4th row | STD |
| 5th row | STD |
Common Values
| Value | Count | Frequency (%) |
| STD | 4882 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| std | 4882 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 4882 | |
| T | 4882 | |
| D | 4882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 14646 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4882 | |
| T | 4882 | |
| D | 4882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14646 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 4882 | |
| T | 4882 | |
| D | 4882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14646 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 4882 | |
| T | 4882 | |
| D | 4882 |
tic
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 498 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| KR | 11 |
|---|---|
| WMT | 11 |
| TGT | 11 |
| GPN | 11 |
| ROST | 11 |
| Other values (493) |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.1519869 |
| Min length | 1 |
Characters and Unicode
| Total characters | 15388 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | AAL |
|---|---|
| 2nd row | AAL |
| 3rd row | AAL |
| 4th row | AAL |
| 5th row | AAL |
Common Values
| Value | Count | Frequency (%) |
| KR | 11 | 0.2% |
| WMT | 11 | 0.2% |
| TGT | 11 | 0.2% |
| GPN | 11 | 0.2% |
| ROST | 11 | 0.2% |
| CRM | 11 | 0.2% |
| MOS | 11 | 0.2% |
| LDOS | 11 | 0.2% |
| NVDA | 11 | 0.2% |
| BBY | 11 | 0.2% |
| Other values (488) | 4772 |
Length
| Value | Count | Frequency (%) |
| kr | 11 | 0.2% |
| dltr | 11 | 0.2% |
| wmt | 11 | 0.2% |
| tjx | 11 | 0.2% |
| low | 11 | 0.2% |
| bbwi | 11 | 0.2% |
| adsk | 11 | 0.2% |
| hd | 11 | 0.2% |
| ulta | 11 | 0.2% |
| khc | 11 | 0.2% |
| Other values (488) | 4772 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1120 | 7.3% |
| C | 1089 | 7.1% |
| T | 979 | 6.4% |
| M | 929 | 6.0% |
| S | 925 | 6.0% |
| R | 860 | 5.6% |
| L | 834 | 5.4% |
| P | 790 | 5.1% |
| E | 786 | 5.1% |
| N | 749 | 4.9% |
| Other values (17) | 6327 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 15368 | |
| Other Punctuation | 20 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1120 | 7.3% |
| C | 1089 | 7.1% |
| T | 979 | 6.4% |
| M | 929 | 6.0% |
| S | 925 | 6.0% |
| R | 860 | 5.6% |
| L | 834 | 5.4% |
| P | 790 | 5.1% |
| E | 786 | 5.1% |
| N | 749 | 4.9% |
| Other values (16) | 6307 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 20 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15368 | |
| Common | 20 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1120 | 7.3% |
| C | 1089 | 7.1% |
| T | 979 | 6.4% |
| M | 929 | 6.0% |
| S | 925 | 6.0% |
| R | 860 | 5.6% |
| L | 834 | 5.4% |
| P | 790 | 5.1% |
| E | 786 | 5.1% |
| N | 749 | 4.9% |
| Other values (16) | 6307 |
Common
| Value | Count | Frequency (%) |
| . | 20 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1120 | 7.3% |
| C | 1089 | 7.1% |
| T | 979 | 6.4% |
| M | 929 | 6.0% |
| S | 925 | 6.0% |
| R | 860 | 5.6% |
| L | 834 | 5.4% |
| P | 790 | 5.1% |
| E | 786 | 5.1% |
| N | 749 | 4.9% |
| Other values (17) | 6327 |
cusip
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 498 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| 501044101 | 11 |
|---|---|
| 931142103 | 11 |
| 87612E106 | 11 |
| 37940X102 | 11 |
| 778296103 | 11 |
| Other values (493) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 43938 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 02376R102 |
|---|---|
| 2nd row | 02376R102 |
| 3rd row | 02376R102 |
| 4th row | 02376R102 |
| 5th row | 02376R102 |
Common Values
| Value | Count | Frequency (%) |
| 501044101 | 11 | 0.2% |
| 931142103 | 11 | 0.2% |
| 87612E106 | 11 | 0.2% |
| 37940X102 | 11 | 0.2% |
| 778296103 | 11 | 0.2% |
| 79466L302 | 11 | 0.2% |
| 61945C103 | 11 | 0.2% |
| 525327102 | 11 | 0.2% |
| 67066G104 | 11 | 0.2% |
| 086516101 | 11 | 0.2% |
| Other values (488) | 4772 |
Length
| Value | Count | Frequency (%) |
| 501044101 | 11 | 0.2% |
| 256746108 | 11 | 0.2% |
| 931142103 | 11 | 0.2% |
| 872540109 | 11 | 0.2% |
| 548661107 | 11 | 0.2% |
| 070830104 | 11 | 0.2% |
| 052769106 | 11 | 0.2% |
| 437076102 | 11 | 0.2% |
| 90384s303 | 11 | 0.2% |
| 500754106 | 11 | 0.2% |
| Other values (488) | 4772 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 8518 | |
| 1 | 7952 | |
| 4 | 3472 | |
| 2 | 3383 | 7.7% |
| 3 | 3350 | 7.6% |
| 5 | 3257 | 7.4% |
| 6 | 3220 | 7.3% |
| 7 | 2905 | 6.6% |
| 9 | 2853 | 6.5% |
| 8 | 2828 | 6.4% |
| Other values (23) | 2200 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 41738 | |
| Uppercase Letter | 2200 | 5.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 283 | 12.9% |
| L | 170 | 7.7% |
| V | 134 | 6.1% |
| C | 132 | 6.0% |
| R | 130 | 5.9% |
| E | 121 | 5.5% |
| T | 120 | 5.5% |
| P | 120 | 5.5% |
| X | 111 | 5.0% |
| H | 100 | 4.5% |
| Other values (13) | 779 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 8518 | |
| 1 | 7952 | |
| 4 | 3472 | |
| 2 | 3383 | 8.1% |
| 3 | 3350 | 8.0% |
| 5 | 3257 | 7.8% |
| 6 | 3220 | 7.7% |
| 7 | 2905 | 7.0% |
| 9 | 2853 | 6.8% |
| 8 | 2828 | 6.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 41738 | |
| Latin | 2200 | 5.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 283 | 12.9% |
| L | 170 | 7.7% |
| V | 134 | 6.1% |
| C | 132 | 6.0% |
| R | 130 | 5.9% |
| E | 121 | 5.5% |
| T | 120 | 5.5% |
| P | 120 | 5.5% |
| X | 111 | 5.0% |
| H | 100 | 4.5% |
| Other values (13) | 779 |
Common
| Value | Count | Frequency (%) |
| 0 | 8518 | |
| 1 | 7952 | |
| 4 | 3472 | |
| 2 | 3383 | 8.1% |
| 3 | 3350 | 8.0% |
| 5 | 3257 | 7.8% |
| 6 | 3220 | 7.7% |
| 7 | 2905 | 7.0% |
| 9 | 2853 | 6.8% |
| 8 | 2828 | 6.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43938 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 8518 | |
| 1 | 7952 | |
| 4 | 3472 | |
| 2 | 3383 | 7.7% |
| 3 | 3350 | 7.6% |
| 5 | 3257 | 7.4% |
| 6 | 3220 | 7.3% |
| 7 | 2905 | 6.6% |
| 9 | 2853 | 6.5% |
| 8 | 2828 | 6.4% |
| Other values (23) | 2200 | 5.0% |
conm
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 498 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| KROGER CO | 11 |
|---|---|
| WALMART INC | 11 |
| TARGET CORP | 11 |
| GLOBAL PAYMENTS INC | 11 |
| ROSS STORES INC | 11 |
| Other values (493) |
Length
| Max length | 28 |
|---|---|
| Median length | 21 |
| Mean length | 17.226137 |
| Min length | 5 |
Characters and Unicode
| Total characters | 84098 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | AMERICAN AIRLINES GROUP INC |
|---|---|
| 2nd row | AMERICAN AIRLINES GROUP INC |
| 3rd row | AMERICAN AIRLINES GROUP INC |
| 4th row | AMERICAN AIRLINES GROUP INC |
| 5th row | AMERICAN AIRLINES GROUP INC |
Common Values
| Value | Count | Frequency (%) |
| KROGER CO | 11 | 0.2% |
| WALMART INC | 11 | 0.2% |
| TARGET CORP | 11 | 0.2% |
| GLOBAL PAYMENTS INC | 11 | 0.2% |
| ROSS STORES INC | 11 | 0.2% |
| SALESFORCE INC | 11 | 0.2% |
| MOSAIC CO | 11 | 0.2% |
| LEIDOS HOLDINGS INC | 11 | 0.2% |
| NVIDIA CORP | 11 | 0.2% |
| BEST BUY CO INC | 11 | 0.2% |
| Other values (488) | 4772 |
Length
| Value | Count | Frequency (%) |
| inc | 2501 | 18.2% |
| corp | 1124 | 8.2% |
| co | 471 | 3.4% |
| group | 228 | 1.7% |
| 212 | 1.5% | |
| energy | 180 | 1.3% |
| plc | 139 | 1.0% |
| financial | 136 | 1.0% |
| technologies | 125 | 0.9% |
| holdings | 114 | 0.8% |
| Other values (703) | 8522 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8900 | ||
| C | 7452 | 8.9% |
| N | 7331 | 8.7% |
| I | 6905 | 8.2% |
| E | 6580 | 7.8% |
| O | 6289 | 7.5% |
| R | 6062 | 7.2% |
| A | 5138 | 6.1% |
| T | 4118 | 4.9% |
| S | 4100 | 4.9% |
| Other values (27) | 21223 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 74317 | |
| Space Separator | 8900 | 10.6% |
| Other Punctuation | 353 | 0.4% |
| Dash Punctuation | 196 | 0.2% |
| Open Punctuation | 141 | 0.2% |
| Close Punctuation | 141 | 0.2% |
| Decimal Number | 50 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 7452 | |
| N | 7331 | |
| I | 6905 | |
| E | 6580 | 8.9% |
| O | 6289 | 8.5% |
| R | 6062 | 8.2% |
| A | 5138 | 6.9% |
| T | 4118 | 5.5% |
| S | 4100 | 5.5% |
| L | 3778 | 5.1% |
| Other values (16) | 16564 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 242 | |
| ' | 51 | 14.4% |
| . | 40 | 11.3% |
| / | 20 | 5.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 20 | |
| 3 | 20 | |
| 5 | 10 |
Space Separator
| Value | Count | Frequency (%) |
| 8900 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 196 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 141 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 141 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 74317 | |
| Common | 9781 | 11.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 7452 | |
| N | 7331 | |
| I | 6905 | |
| E | 6580 | 8.9% |
| O | 6289 | 8.5% |
| R | 6062 | 8.2% |
| A | 5138 | 6.9% |
| T | 4118 | 5.5% |
| S | 4100 | 5.5% |
| L | 3778 | 5.1% |
| Other values (16) | 16564 |
Common
| Value | Count | Frequency (%) |
| 8900 | ||
| & | 242 | 2.5% |
| - | 196 | 2.0% |
| ( | 141 | 1.4% |
| ) | 141 | 1.4% |
| ' | 51 | 0.5% |
| . | 40 | 0.4% |
| / | 20 | 0.2% |
| 6 | 20 | 0.2% |
| 3 | 20 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 84098 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8900 | ||
| C | 7452 | 8.9% |
| N | 7331 | 8.7% |
| I | 6905 | 8.2% |
| E | 6580 | 7.8% |
| O | 6289 | 7.5% |
| R | 6062 | 7.2% |
| A | 5138 | 6.1% |
| T | 4118 | 4.9% |
| S | 4100 | 4.9% |
| Other values (27) | 21223 |
curcd
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| USD |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14646 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | USD |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 4882 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 4882 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 4882 | |
| S | 4882 | |
| D | 4882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 14646 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 4882 | |
| S | 4882 | |
| D | 4882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14646 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 4882 | |
| S | 4882 | |
| D | 4882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14646 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 4882 | |
| S | 4882 | |
| D | 4882 |
fyr
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.624334 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.897732 |
|---|---|
| Coefficient of variation (CV) | 0.27274481 |
| Kurtosis | 3.3461639 |
| Mean | 10.624334 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.113947 |
| Sum | 51868 |
| Variance | 8.3968509 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 3730 | |
| 9 | 248 | 5.1% |
| 6 | 222 | 4.5% |
| 1 | 168 | 3.4% |
| 10 | 115 | 2.4% |
| 5 | 98 | 2.0% |
| 3 | 90 | 1.8% |
| 8 | 60 | 1.2% |
| 4 | 44 | 0.9% |
| 11 | 44 | 0.9% |
| Other values (2) | 63 | 1.3% |
| Value | Count | Frequency (%) |
| 1 | 168 | |
| 2 | 23 | 0.5% |
| 3 | 90 | 1.8% |
| 4 | 44 | 0.9% |
| 5 | 98 | 2.0% |
| 6 | 222 | |
| 7 | 40 | 0.8% |
| 8 | 60 | 1.2% |
| 9 | 248 | |
| 10 | 115 |
| Value | Count | Frequency (%) |
| 12 | 3730 | |
| 11 | 44 | 0.9% |
| 10 | 115 | 2.4% |
| 9 | 248 | 5.1% |
| 8 | 60 | 1.2% |
| 7 | 40 | 0.8% |
| 6 | 222 | 4.5% |
| 5 | 98 | 2.0% |
| 4 | 44 | 0.9% |
| 3 | 90 | 1.8% |
act
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 3933 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 864 |
| Missing (%) | 17.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8405.045 |
| Minimum | 25.037 |
|---|---|
| Maximum | 175552 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 25.037 |
|---|---|
| 5-th percentile | 511.6895 |
| Q1 | 1581.8093 |
| median | 3325.052 |
| Q3 | 8251.25 |
| 95-th percentile | 34450.7 |
| Maximum | 175552 |
| Range | 175526.96 |
| Interquartile range (IQR) | 6669.4407 |
Descriptive statistics
| Standard deviation | 14911.298 |
|---|---|
| Coefficient of variation (CV) | 1.774089 |
| Kurtosis | 30.076035 |
| Mean | 8405.045 |
| Median Absolute Deviation (MAD) | 2255.3515 |
| Skewness | 4.6199071 |
| Sum | 33771471 |
| Variance | 2.223468 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1527 | 3 | 0.1% |
| 13704 | 2 | < 0.1% |
| 2730 | 2 | < 0.1% |
| 3507 | 2 | < 0.1% |
| 2971.9 | 2 | < 0.1% |
| 3033 | 2 | < 0.1% |
| 4404 | 2 | < 0.1% |
| 3836 | 2 | < 0.1% |
| 3465 | 2 | < 0.1% |
| 10566 | 2 | < 0.1% |
| Other values (3923) | 3997 | |
| (Missing) | 864 | 17.7% |
| Value | Count | Frequency (%) |
| 25.037 | 1 | |
| 30.933 | 1 | |
| 44.173 | 1 | |
| 47.492 | 1 | |
| 50.275 | 1 | |
| 52.956 | 1 | |
| 61.968 | 1 | |
| 66.025 | 1 | |
| 69.273 | 1 | |
| 76.785 | 1 |
| Value | Count | Frequency (%) |
| 175552 | 1 | |
| 169662 | 1 | |
| 162819 | 1 | |
| 159851 | 1 | |
| 152578 | 1 | |
| 139660 | 1 | |
| 135676 | 1 | |
| 131339 | 1 | |
| 128645 | 1 | |
| 124712 | 1 |
at
Real number (ℝ)
| Distinct | 4833 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 23 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62633.461 |
| Minimum | 49.086 |
|---|---|
| Maximum | 2687379 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 49.086 |
|---|---|
| 5-th percentile | 1589.575 |
| Q1 | 5876.451 |
| median | 15647.066 |
| Q3 | 40319.5 |
| 95-th percentile | 221765.9 |
| Maximum | 2687379 |
| Range | 2687329.9 |
| Interquartile range (IQR) | 34443.049 |
Descriptive statistics
| Standard deviation | 209674.28 |
|---|---|
| Coefficient of variation (CV) | 3.34764 |
| Kurtosis | 76.883658 |
| Mean | 62633.461 |
| Median Absolute Deviation (MAD) | 11797.534 |
| Skewness | 8.1601373 |
| Sum | 3.0433599 × 108 |
| Variance | 4.3963304 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20497 | 2 | < 0.1% |
| 18174 | 2 | < 0.1% |
| 34309 | 2 | < 0.1% |
| 20386 | 2 | < 0.1% |
| 6184 | 2 | < 0.1% |
| 13459 | 2 | < 0.1% |
| 20038 | 2 | < 0.1% |
| 6262 | 2 | < 0.1% |
| 45058 | 2 | < 0.1% |
| 121347 | 2 | < 0.1% |
| Other values (4823) | 4839 | |
| (Missing) | 23 | 0.5% |
| Value | Count | Frequency (%) |
| 49.086 | 1 | |
| 51.369 | 1 | |
| 59.504 | 1 | |
| 74.998 | 1 | |
| 77.164 | 1 | |
| 106 | 1 | |
| 106.159 | 1 | |
| 106.242 | 1 | |
| 108.746 | 1 | |
| 116.669 | 1 |
| Value | Count | Frequency (%) |
| 2687379 | 1 | |
| 2622532 | 1 | |
| 2573126 | 1 | |
| 2533600 | 1 | |
| 2490972 | 1 | |
| 2434079 | 1 | |
| 2415689 | 1 | |
| 2359141 | 1 | |
| 2354507 | 1 | |
| 2351698 | 1 |
bkvlps
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 4795 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 70 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7929.4908 |
| Minimum | -125.6877 |
|---|---|
| Maximum | 16297416 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 182 |
| Negative (%) | 3.7% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -125.6877 |
|---|---|
| 5-th percentile | 1.519805 |
| Q1 | 9.953625 |
| median | 18.384 |
| Q3 | 32.573475 |
| 95-th percentile | 72.674025 |
| Maximum | 16297416 |
| Range | 16297542 |
| Interquartile range (IQR) | 22.61985 |
Descriptive statistics
| Standard deviation | 327827.78 |
|---|---|
| Coefficient of variation (CV) | 41.342855 |
| Kurtosis | 2288.1667 |
| Mean | 7929.4908 |
| Median Absolute Deviation (MAD) | 10.1635 |
| Skewness | 47.362372 |
| Sum | 38156710 |
| Variance | 1.0747106 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23.3468 | 2 | < 0.1% |
| 10.3063 | 2 | < 0.1% |
| 12.9776 | 2 | < 0.1% |
| 5.9736 | 2 | < 0.1% |
| 5.4405 | 2 | < 0.1% |
| 7.7707 | 2 | < 0.1% |
| 60.1364 | 2 | < 0.1% |
| 21.4568 | 2 | < 0.1% |
| 19.8094 | 2 | < 0.1% |
| 21.4275 | 2 | < 0.1% |
| Other values (4785) | 4792 | |
| (Missing) | 70 | 1.4% |
| Value | Count | Frequency (%) |
| -125.6877 | 1 | |
| -87.732 | 1 | |
| -74.1842 | 1 | |
| -71.2976 | 1 | |
| -70.1814 | 1 | |
| -63.7648 | 1 | |
| -61.3894 | 1 | |
| -59.0613 | 1 | |
| -56.826 | 1 | |
| -55.494 | 1 |
| Value | Count | Frequency (%) |
| 16297416 | 1 | |
| 15437843 | 1 | |
| 2455471 | 1 | |
| 1956293 | 1 | |
| 1885901 | 1 | |
| 644.4382 | 1 | |
| 505.4673 | 1 | |
| 434.9748 | 1 | |
| 353.2199 | 1 | |
| 325.8986 | 1 |
capx
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 3888 |
|---|---|
| Distinct (%) | 80.2% |
| Missing | 33 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1241.3741 |
| Minimum | 0 |
|---|---|
| Maximum | 37985 |
| Zeros | 309 |
| Zeros (%) | 6.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 83.435 |
| median | 280.873 |
| Q3 | 1113 |
| 95-th percentile | 5164.8 |
| Maximum | 37985 |
| Range | 37985 |
| Interquartile range (IQR) | 1029.565 |
Descriptive statistics
| Standard deviation | 2924.7561 |
|---|---|
| Coefficient of variation (CV) | 2.3560635 |
| Kurtosis | 44.020255 |
| Mean | 1241.3741 |
| Median Absolute Deviation (MAD) | 255.191 |
| Skewness | 5.7506115 |
| Sum | 6019422.9 |
| Variance | 8554198.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 309 | 6.3% |
| 145 | 7 | 0.1% |
| 121 | 7 | 0.1% |
| 593 | 7 | 0.1% |
| 180 | 7 | 0.1% |
| 119 | 7 | 0.1% |
| 162 | 7 | 0.1% |
| 246 | 6 | 0.1% |
| 224 | 5 | 0.1% |
| 422 | 5 | 0.1% |
| Other values (3878) | 4482 | |
| (Missing) | 33 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 309 | |
| 0.42 | 1 | < 0.1% |
| 0.899 | 1 | < 0.1% |
| 1.384 | 1 | < 0.1% |
| 1.506 | 1 | < 0.1% |
| 1.539 | 1 | < 0.1% |
| 1.584 | 1 | < 0.1% |
| 1.945 | 1 | < 0.1% |
| 2.031 | 1 | < 0.1% |
| 2.2 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 37985 | 1 | |
| 35407 | 1 | |
| 34271 | 1 | |
| 33669 | 1 | |
| 32952 | 1 | |
| 30975 | 1 | |
| 30938 | 1 | |
| 29504 | 1 | |
| 29166 | 1 | |
| 27633 | 1 |
ceql
Real number (ℝ)
| Distinct | 4785 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 24 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13133.283 |
| Minimum | -13244 |
|---|---|
| Maximum | 424791 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 182 |
| Negative (%) | 3.7% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -13244 |
|---|---|
| 5-th percentile | 187.0476 |
| Q1 | 1955.957 |
| median | 4995.85 |
| Q3 | 11724.797 |
| 95-th percentile | 51662.85 |
| Maximum | 424791 |
| Range | 438035 |
| Interquartile range (IQR) | 9768.84 |
Descriptive statistics
| Standard deviation | 28367.252 |
|---|---|
| Coefficient of variation (CV) | 2.1599514 |
| Kurtosis | 41.736409 |
| Mean | 13133.283 |
| Median Absolute Deviation (MAD) | 3681.3425 |
| Skewness | 5.6140678 |
| Sum | 63801487 |
| Variance | 8.0470099 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23771 | 2 | < 0.1% |
| 5488 | 2 | < 0.1% |
| 4752 | 2 | < 0.1% |
| 1145 | 2 | < 0.1% |
| -60 | 2 | < 0.1% |
| -102 | 2 | < 0.1% |
| 1454 | 2 | < 0.1% |
| 7336 | 2 | < 0.1% |
| 8380 | 2 | < 0.1% |
| 1045.5 | 2 | < 0.1% |
| Other values (4775) | 4838 | |
| (Missing) | 24 | 0.5% |
| Value | Count | Frequency (%) |
| -13244 | 1 | |
| -12688 | 1 | |
| -12629 | 1 | |
| -12459 | 1 | |
| -12086 | 1 | |
| -11926 | 1 | |
| -11577 | 1 | |
| -9660 | 1 | |
| -8617 | 1 | |
| -8446 | 1 |
| Value | Count | Frequency (%) |
| 424791 | 1 | |
| 348703 | 1 | |
| 348296 | 1 | |
| 283001 | 1 | |
| 255550 | 1 | |
| 244823 | 1 | |
| 242999 | 1 | |
| 241620 | 1 | |
| 241409 | 1 | |
| 240170 | 1 |
csho
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 4641 |
|---|---|
| Distinct (%) | 96.4% |
| Missing | 69 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 597.31446 |
| Minimum | 0.001 |
|---|---|
| Maximum | 29058.361 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0.001 |
|---|---|
| 5-th percentile | 47.3654 |
| Q1 | 129.954 |
| median | 281 |
| Q3 | 561 |
| 95-th percentile | 2098.8932 |
| Maximum | 29058.361 |
| Range | 29058.36 |
| Interquartile range (IQR) | 431.046 |
Descriptive statistics
| Standard deviation | 1161.9103 |
|---|---|
| Coefficient of variation (CV) | 1.9452238 |
| Kurtosis | 98.837772 |
| Mean | 597.31446 |
| Median Absolute Deviation (MAD) | 174 |
| Skewness | 7.1858145 |
| Sum | 2874874.5 |
| Variance | 1350035.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 325.811 | 9 | 0.2% |
| 242.6 | 7 | 0.1% |
| 0.001 | 5 | 0.1% |
| 333 | 4 | 0.1% |
| 321 | 4 | 0.1% |
| 418 | 3 | 0.1% |
| 147 | 3 | 0.1% |
| 776 | 3 | 0.1% |
| 585 | 3 | 0.1% |
| 967 | 3 | 0.1% |
| Other values (4631) | 4769 | |
| (Missing) | 69 | 1.4% |
| Value | Count | Frequency (%) |
| 0.001 | 5 | |
| 0.271 | 2 | < 0.1% |
| 0.843 | 1 | < 0.1% |
| 1.011 | 1 | < 0.1% |
| 1.013 | 1 | < 0.1% |
| 1.015 | 1 | < 0.1% |
| 1.698 | 1 | < 0.1% |
| 2.782 | 1 | < 0.1% |
| 2.81 | 1 | < 0.1% |
| 3.578 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 29058.361 | 1 | |
| 10778.264 | 1 | |
| 10615.376 | 1 | |
| 10591.808 | 1 | |
| 10573.017 | 1 | |
| 10535.938 | 1 | |
| 10516.542 | 1 | |
| 10405.625 | 1 | |
| 10380.265 | 1 | |
| 10287.302 | 1 |
dltt
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 4407 |
|---|---|
| Distinct (%) | 91.0% |
| Missing | 40 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10426.34 |
| Minimum | 0 |
|---|---|
| Maximum | 359180 |
| Zeros | 258 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1108.1715 |
| median | 3662.1 |
| Q3 | 9365.4837 |
| 95-th percentile | 33532.5 |
| Maximum | 359180 |
| Range | 359180 |
| Interquartile range (IQR) | 8257.3122 |
Descriptive statistics
| Standard deviation | 26635.715 |
|---|---|
| Coefficient of variation (CV) | 2.5546562 |
| Kurtosis | 53.936952 |
| Mean | 10426.34 |
| Median Absolute Deviation (MAD) | 3057.862 |
| Skewness | 6.7206404 |
| Sum | 50484339 |
| Variance | 7.0946131 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 258 | 5.3% |
| 250 | 13 | 0.3% |
| 500 | 8 | 0.2% |
| 150 | 7 | 0.1% |
| 499 | 4 | 0.1% |
| 799 | 3 | 0.1% |
| 3935 | 3 | 0.1% |
| 575 | 3 | 0.1% |
| 750 | 3 | 0.1% |
| 1099 | 3 | 0.1% |
| Other values (4397) | 4537 | |
| (Missing) | 40 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 258 | |
| 0.018 | 1 | < 0.1% |
| 0.022 | 1 | < 0.1% |
| 0.038 | 1 | < 0.1% |
| 0.193 | 1 | < 0.1% |
| 0.349 | 1 | < 0.1% |
| 0.457 | 1 | < 0.1% |
| 0.485 | 1 | < 0.1% |
| 0.509 | 1 | < 0.1% |
| 0.648 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 359180 | 1 | |
| 324782 | 1 | |
| 309710 | 1 | |
| 279618 | 1 | |
| 274873 | 1 | |
| 274850 | 1 | |
| 271245 | 1 | |
| 268676 | 1 | |
| 268522 | 1 | |
| 266303 | 1 |
dt
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 3959 |
|---|---|
| Distinct (%) | 91.3% |
| Missing | 548 |
| Missing (%) | 11.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9866.0364 |
| Minimum | 0 |
|---|---|
| Maximum | 426314 |
| Zeros | 237 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1033.7673 |
| median | 3395.356 |
| Q3 | 8691.365 |
| 95-th percentile | 32392 |
| Maximum | 426314 |
| Range | 426314 |
| Interquartile range (IQR) | 7657.5977 |
Descriptive statistics
| Standard deviation | 26541.057 |
|---|---|
| Coefficient of variation (CV) | 2.6901438 |
| Kurtosis | 82.503456 |
| Mean | 9866.0364 |
| Median Absolute Deviation (MAD) | 2840.5 |
| Skewness | 8.0090617 |
| Sum | 42759402 |
| Variance | 7.044277 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 237 | 4.9% |
| 250 | 9 | 0.2% |
| 500 | 5 | 0.1% |
| 150 | 5 | 0.1% |
| 799 | 3 | 0.1% |
| 827 | 3 | 0.1% |
| 35 | 3 | 0.1% |
| 1199 | 3 | 0.1% |
| 12825 | 3 | 0.1% |
| 6838 | 3 | 0.1% |
| Other values (3949) | 4060 | |
| (Missing) | 548 | 11.2% |
| Value | Count | Frequency (%) |
| 0 | 237 | |
| 0.009 | 1 | < 0.1% |
| 0.033 | 1 | < 0.1% |
| 0.056 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.274 | 1 | < 0.1% |
| 0.338 | 1 | < 0.1% |
| 0.349 | 1 | < 0.1% |
| 0.509 | 1 | < 0.1% |
| 0.525 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 426314 | 1 | |
| 398523 | 1 | |
| 381183 | 1 | |
| 362000 | 1 | |
| 344435 | 1 | |
| 333248 | 1 | |
| 323505 | 1 | |
| 273058 | 1 | |
| 272565 | 1 | |
| 259374 | 1 |
dvp
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 411 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 25 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.204622 |
| Minimum | -112 |
|---|---|
| Maximum | 2018 |
| Zeros | 4213 |
| Zeros (%) | 86.3% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -112 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 73 |
| Maximum | 2018 |
| Range | 2130 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 134.4147 |
|---|---|
| Coefficient of variation (CV) | 6.053456 |
| Kurtosis | 99.483079 |
| Mean | 22.204622 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.4181971 |
| Sum | 107847.85 |
| Variance | 18067.311 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4213 | |
| 1 | 20 | 0.4% |
| 2 | 12 | 0.2% |
| 14 | 12 | 0.2% |
| 3.337 | 9 | 0.2% |
| 340 | 8 | 0.2% |
| 0.541 | 7 | 0.1% |
| 10.5 | 6 | 0.1% |
| 3 | 6 | 0.1% |
| 10.2 | 6 | 0.1% |
| Other values (401) | 558 | 11.4% |
| (Missing) | 25 | 0.5% |
| Value | Count | Frequency (%) |
| -112 | 1 | < 0.1% |
| -29 | 1 | < 0.1% |
| 0 | 4213 | |
| 0.008 | 1 | < 0.1% |
| 0.009 | 2 | < 0.1% |
| 0.012 | 2 | < 0.1% |
| 0.019 | 1 | < 0.1% |
| 0.03 | 5 | 0.1% |
| 0.153 | 1 | < 0.1% |
| 0.224 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2018 | 1 | |
| 1932 | 1 | |
| 1704 | 1 | |
| 1682 | 1 | |
| 1663 | 1 | |
| 1647 | 1 | |
| 1629 | 1 | |
| 1614 | 1 | |
| 1611 | 1 | |
| 1587 | 1 |
ebitda
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 4410 |
|---|---|
| Distinct (%) | 95.5% |
| Missing | 264 |
| Missing (%) | 5.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4396.5382 |
| Minimum | -21913 |
|---|---|
| Maximum | 115545 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 62 |
| Negative (%) | 1.3% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -21913 |
|---|---|
| 5-th percentile | 203.3093 |
| Q1 | 811 |
| median | 1842.65 |
| Q3 | 4303.875 |
| 95-th percentile | 17405.75 |
| Maximum | 115545 |
| Range | 137458 |
| Interquartile range (IQR) | 3492.875 |
Descriptive statistics
| Standard deviation | 8160.3083 |
|---|---|
| Coefficient of variation (CV) | 1.8560758 |
| Kurtosis | 29.223214 |
| Mean | 4396.5382 |
| Median Absolute Deviation (MAD) | 1280.1 |
| Skewness | 4.6450564 |
| Sum | 20303213 |
| Variance | 66590632 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4854 | 4 | 0.1% |
| 2108 | 4 | 0.1% |
| 811 | 3 | 0.1% |
| 2113 | 3 | 0.1% |
| 1684 | 3 | 0.1% |
| 1088 | 3 | 0.1% |
| 1221 | 3 | 0.1% |
| 809 | 3 | 0.1% |
| 2997 | 3 | 0.1% |
| 3319 | 3 | 0.1% |
| Other values (4400) | 4586 | |
| (Missing) | 264 | 5.4% |
| Value | Count | Frequency (%) |
| -21913 | 1 | |
| -15891 | 1 | |
| -9647 | 1 | |
| -4171 | 1 | |
| -3124 | 1 | |
| -2185 | 1 | |
| -2007 | 1 | |
| -1792 | 1 | |
| -927 | 1 | |
| -666.676 | 1 |
| Value | Count | Frequency (%) |
| 115545 | 1 | |
| 81730 | 1 | |
| 79962 | 1 | |
| 75230 | 1 | |
| 71565 | 1 | |
| 70744 | 1 | |
| 69687 | 1 | |
| 69276 | 1 | |
| 67089 | 1 | |
| 65769 | 1 |
emp
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 2853 |
|---|---|
| Distinct (%) | 59.3% |
| Missing | 71 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.071399 |
| Minimum | 0.052 |
|---|---|
| Maximum | 2300 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0.052 |
|---|---|
| 5-th percentile | 1.215 |
| Q1 | 7 |
| median | 17 |
| Q3 | 50 |
| 95-th percentile | 223.3575 |
| Maximum | 2300 |
| Range | 2299.948 |
| Interquartile range (IQR) | 43 |
Descriptive statistics
| Standard deviation | 128.09718 |
|---|---|
| Coefficient of variation (CV) | 2.5081979 |
| Kurtosis | 184.29779 |
| Mean | 51.071399 |
| Median Absolute Deviation (MAD) | 13.286 |
| Skewness | 11.594522 |
| Sum | 245704.5 |
| Variance | 16408.886 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 24 | 0.5% |
| 30 | 23 | 0.5% |
| 5 | 22 | 0.5% |
| 14 | 22 | 0.5% |
| 25 | 19 | 0.4% |
| 24 | 19 | 0.4% |
| 50 | 18 | 0.4% |
| 22 | 18 | 0.4% |
| 7 | 17 | 0.3% |
| 35 | 17 | 0.3% |
| Other values (2843) | 4612 | |
| (Missing) | 71 | 1.5% |
| Value | Count | Frequency (%) |
| 0.052 | 1 | < 0.1% |
| 0.068 | 1 | < 0.1% |
| 0.079 | 1 | < 0.1% |
| 0.083 | 1 | < 0.1% |
| 0.097 | 1 | < 0.1% |
| 0.114 | 1 | < 0.1% |
| 0.116 | 1 | < 0.1% |
| 0.125 | 1 | < 0.1% |
| 0.132 | 1 | < 0.1% |
| 0.14 | 3 |
| Value | Count | Frequency (%) |
| 2300 | 3 | |
| 2200 | 6 | |
| 2100 | 2 | < 0.1% |
| 798 | 1 | < 0.1% |
| 647.5 | 1 | < 0.1% |
| 566 | 1 | < 0.1% |
| 539 | 1 | < 0.1% |
| 537 | 1 | < 0.1% |
| 523 | 1 | < 0.1% |
| 505 | 1 | < 0.1% |
lct
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 3904 |
|---|---|
| Distinct (%) | 97.1% |
| Missing | 860 |
| Missing (%) | 17.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6214.9261 |
| Minimum | 13.203 |
|---|---|
| Maximum | 116866 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 13.203 |
|---|---|
| 5-th percentile | 238.62265 |
| Q1 | 933.992 |
| median | 2418.283 |
| Q3 | 6052.5 |
| 95-th percentile | 26616.55 |
| Maximum | 116866 |
| Range | 116852.8 |
| Interquartile range (IQR) | 5118.508 |
Descriptive statistics
| Standard deviation | 11160.336 |
|---|---|
| Coefficient of variation (CV) | 1.7957311 |
| Kurtosis | 22.712287 |
| Mean | 6214.9261 |
| Median Absolute Deviation (MAD) | 1812.6045 |
| Skewness | 4.2022502 |
| Sum | 24996433 |
| Variance | 1.245531 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5374 | 3 | 0.1% |
| 2467 | 3 | 0.1% |
| 3485 | 3 | 0.1% |
| 12708 | 3 | 0.1% |
| 1501 | 3 | 0.1% |
| 2747 | 3 | 0.1% |
| 2611 | 3 | 0.1% |
| 2265 | 3 | 0.1% |
| 3577 | 2 | < 0.1% |
| 3385 | 2 | < 0.1% |
| Other values (3894) | 3994 | |
| (Missing) | 860 | 17.6% |
| Value | Count | Frequency (%) |
| 13.203 | 1 | |
| 14.741 | 1 | |
| 15.129 | 1 | |
| 17.024 | 1 | |
| 18.188 | 1 | |
| 19.219 | 1 | |
| 19.5 | 1 | |
| 20.01 | 1 | |
| 23.46 | 1 | |
| 26.07 | 1 |
| Value | Count | Frequency (%) |
| 116866 | 1 | |
| 105718 | 1 | |
| 100814 | 1 | |
| 98132 | 1 | |
| 97312 | 1 | |
| 95569 | 1 | |
| 94600 | 1 | |
| 90281 | 1 | |
| 87812 | 1 | |
| 85181 | 1 |
lt
Real number (ℝ)
| Distinct | 4805 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 37 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48936.046 |
| Minimum | 15.985 |
|---|---|
| Maximum | 2426049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 15.985 |
|---|---|
| 5-th percentile | 597.4024 |
| Q1 | 3348 |
| median | 9683.453 |
| Q3 | 27430 |
| 95-th percentile | 165172.6 |
| Maximum | 2426049 |
| Range | 2426033 |
| Interquartile range (IQR) | 24082 |
Descriptive statistics
| Standard deviation | 186723.4 |
|---|---|
| Coefficient of variation (CV) | 3.8156618 |
| Kurtosis | 81.014572 |
| Mean | 48936.046 |
| Median Absolute Deviation (MAD) | 7774.494 |
| Skewness | 8.4483769 |
| Sum | 2.3709514 × 108 |
| Variance | 3.4865628 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13794 | 2 | < 0.1% |
| 34596 | 2 | < 0.1% |
| 3492 | 2 | < 0.1% |
| 47751 | 2 | < 0.1% |
| 2997.8 | 2 | < 0.1% |
| 16374 | 2 | < 0.1% |
| 56737 | 2 | < 0.1% |
| 14037 | 2 | < 0.1% |
| 14229 | 2 | < 0.1% |
| 6779 | 2 | < 0.1% |
| Other values (4795) | 4825 | |
| (Missing) | 37 | 0.8% |
| Value | Count | Frequency (%) |
| 15.985 | 1 | |
| 16.171 | 1 | |
| 17.024 | 1 | |
| 21.023 | 1 | |
| 21.944 | 1 | |
| 28.868 | 1 | |
| 29 | 1 | |
| 30.99 | 1 | |
| 31.548 | 1 | |
| 34.708 | 1 |
| Value | Count | Frequency (%) |
| 2426049 | 1 | |
| 2366017 | 1 | |
| 2341061 | 1 | |
| 2277907 | 1 | |
| 2236782 | 1 | |
| 2204511 | 1 | |
| 2169269 | 1 | |
| 2155072 | 1 | |
| 2104125 | 1 | |
| 2089182 | 1 |
ni
Real number (ℝ)
| Distinct | 4477 |
|---|---|
| Distinct (%) | 92.2% |
| Missing | 25 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1920.1609 |
| Minimum | -23119 |
|---|---|
| Maximum | 81417 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 342 |
| Negative (%) | 7.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -23119 |
|---|---|
| 5-th percentile | -97.7168 |
| Q1 | 286.198 |
| median | 704.422 |
| Q3 | 1889 |
| 95-th percentile | 8169.8 |
| Maximum | 81417 |
| Range | 104536 |
| Interquartile range (IQR) | 1602.802 |
Descriptive statistics
| Standard deviation | 4385.3296 |
|---|---|
| Coefficient of variation (CV) | 2.2838344 |
| Kurtosis | 59.008623 |
| Mean | 1920.1609 |
| Median Absolute Deviation (MAD) | 544.295 |
| Skewness | 5.8889373 |
| Sum | 9326221.7 |
| Variance | 19231116 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 263 | 4 | 0.1% |
| 753 | 4 | 0.1% |
| 591 | 4 | 0.1% |
| 477 | 4 | 0.1% |
| 1979 | 4 | 0.1% |
| 858 | 4 | 0.1% |
| 470 | 3 | 0.1% |
| 242 | 3 | 0.1% |
| 817 | 3 | 0.1% |
| 563 | 3 | 0.1% |
| Other values (4467) | 4821 | |
| (Missing) | 25 | 0.5% |
| Value | Count | Frequency (%) |
| -23119 | 1 | |
| -22355 | 1 | |
| -14454 | 1 | |
| -12650 | 1 | |
| -12236 | 1 | |
| -10192 | 1 | |
| -10137 | 1 | |
| -7829 | 1 | |
| -7642 | 1 | |
| -6917.9 | 1 |
| Value | Count | Frequency (%) |
| 81417 | 1 | |
| 59531 | 1 | |
| 55256 | 1 | |
| 53394 | 1 | |
| 48351 | 1 | |
| 45687 | 1 | |
| 44940 | 1 | |
| 44880 | 1 | |
| 41733 | 1 | |
| 41060 | 1 |
ppegt
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 4278 |
|---|---|
| Distinct (%) | 98.1% |
| Missing | 522 |
| Missing (%) | 10.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16275.383 |
| Minimum | 0 |
|---|---|
| Maximum | 493335 |
| Zeros | 9 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 207.6715 |
| Q1 | 1150 |
| median | 3925 |
| Q3 | 16270.75 |
| 95-th percentile | 61051.5 |
| Maximum | 493335 |
| Range | 493335 |
| Interquartile range (IQR) | 15120.75 |
Descriptive statistics
| Standard deviation | 38028.927 |
|---|---|
| Coefficient of variation (CV) | 2.3365919 |
| Kurtosis | 55.465276 |
| Mean | 16275.383 |
| Median Absolute Deviation (MAD) | 3406.88 |
| Skewness | 6.4634165 |
| Sum | 70960670 |
| Variance | 1.4461993 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9 | 0.2% |
| 866 | 3 | 0.1% |
| 1733 | 3 | 0.1% |
| 1063 | 3 | 0.1% |
| 1054 | 3 | 0.1% |
| 2500 | 3 | 0.1% |
| 2000 | 3 | 0.1% |
| 858 | 2 | < 0.1% |
| 33686 | 2 | < 0.1% |
| 2139.3 | 2 | < 0.1% |
| Other values (4268) | 4327 | |
| (Missing) | 522 | 10.7% |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 2.348 | 1 | < 0.1% |
| 8.81 | 1 | < 0.1% |
| 9.3 | 1 | < 0.1% |
| 11.57 | 1 | < 0.1% |
| 12.146 | 1 | < 0.1% |
| 12.297 | 1 | < 0.1% |
| 13.552 | 1 | < 0.1% |
| 15.09 | 1 | < 0.1% |
| 21.774 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 493335 | 1 | |
| 477190 | 1 | |
| 477185 | 1 | |
| 453915 | 1 | |
| 447337 | 1 | |
| 446789 | 1 | |
| 434517 | 1 | |
| 409314 | 1 | |
| 393995 | 1 | |
| 373938 | 1 |
pstkl
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 390 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 32 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 317.7737 |
| Minimum | 0 |
|---|---|
| Maximum | 49148 |
| Zeros | 4147 |
| Zeros (%) | 84.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1041.85 |
| Maximum | 49148 |
| Range | 49148 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2022.1028 |
|---|---|
| Coefficient of variation (CV) | 6.3633424 |
| Kurtosis | 154.19309 |
| Mean | 317.7737 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.024392 |
| Sum | 1541202.4 |
| Variance | 4088899.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4147 | |
| 200 | 15 | 0.3% |
| 325 | 11 | 0.2% |
| 30.4 | 10 | 0.2% |
| 39.847 | 10 | 0.2% |
| 0.3 | 10 | 0.2% |
| 142 | 10 | 0.2% |
| 575 | 9 | 0.2% |
| 155.6 | 8 | 0.2% |
| 1000 | 8 | 0.2% |
| Other values (380) | 612 | 12.5% |
| (Missing) | 32 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 4147 | |
| 0.015 | 3 | 0.1% |
| 0.057 | 4 | 0.1% |
| 0.058 | 2 | < 0.1% |
| 0.061 | 1 | < 0.1% |
| 0.069 | 1 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.236 | 1 | < 0.1% |
| 0.3 | 10 | 0.2% |
| 0.551 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49148 | 1 | < 0.1% |
| 26993 | 1 | < 0.1% |
| 26068 | 4 | |
| 25969.47 | 1 | < 0.1% |
| 25659.47 | 1 | < 0.1% |
| 25220 | 1 | < 0.1% |
| 23819.47 | 1 | < 0.1% |
| 23401 | 1 | < 0.1% |
| 23359.47 | 1 | < 0.1% |
| 22326 | 1 | < 0.1% |
revt
Real number (ℝ)
| Distinct | 4807 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 25 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21176.691 |
| Minimum | 27.253 |
|---|---|
| Maximum | 521426 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 27.253 |
|---|---|
| 5-th percentile | 923.8702 |
| Q1 | 3326.445 |
| median | 8073.855 |
| Q3 | 18031 |
| 95-th percentile | 93525.6 |
| Maximum | 521426 |
| Range | 521398.75 |
| Interquartile range (IQR) | 14704.555 |
Descriptive statistics
| Standard deviation | 41346.83 |
|---|---|
| Coefficient of variation (CV) | 1.9524688 |
| Kurtosis | 44.33917 |
| Mean | 21176.691 |
| Median Absolute Deviation (MAD) | 5722.145 |
| Skewness | 5.4985157 |
| Sum | 1.0285519 × 108 |
| Variance | 1.7095604 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7059 | 2 | < 0.1% |
| 5539 | 2 | < 0.1% |
| 11454 | 2 | < 0.1% |
| 5763 | 2 | < 0.1% |
| 14945 | 2 | < 0.1% |
| 62484 | 2 | < 0.1% |
| 48158 | 2 | < 0.1% |
| 8521 | 2 | < 0.1% |
| 9968 | 2 | < 0.1% |
| 5010 | 2 | < 0.1% |
| Other values (4797) | 4837 | |
| (Missing) | 25 | 0.5% |
| Value | Count | Frequency (%) |
| 27.253 | 1 | |
| 43.329 | 1 | |
| 48.631 | 1 | |
| 48.672 | 1 | |
| 60.209 | 1 | |
| 61.661 | 1 | |
| 74.962 | 1 | |
| 76.266 | 1 | |
| 76.81 | 1 | |
| 79.035 | 1 |
| Value | Count | Frequency (%) |
| 521426 | 1 | |
| 511729 | 1 | |
| 496785 | 1 | |
| 483521 | 1 | |
| 482154 | 1 | |
| 479962 | 1 | |
| 474259 | 1 | |
| 467231 | 1 | |
| 444948 | 1 | |
| 433526 | 1 |
seq
Real number (ℝ)
| Distinct | 4784 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 23 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13441.878 |
| Minimum | -13244 |
|---|---|
| Maximum | 424791 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 178 |
| Negative (%) | 3.6% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -13244 |
|---|---|
| 5-th percentile | 188.5761 |
| Q1 | 1961.916 |
| median | 5047.208 |
| Q3 | 11876.4 |
| 95-th percentile | 52065.7 |
| Maximum | 424791 |
| Range | 438035 |
| Interquartile range (IQR) | 9914.484 |
Descriptive statistics
| Standard deviation | 29471.794 |
|---|---|
| Coefficient of variation (CV) | 2.1925355 |
| Kurtosis | 41.673893 |
| Mean | 13441.878 |
| Median Absolute Deviation (MAD) | 3739.008 |
| Skewness | 5.6761767 |
| Sum | 65314084 |
| Variance | 8.6858667 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10381 | 3 | 0.1% |
| 2162 | 3 | 0.1% |
| -102 | 2 | < 0.1% |
| 7336 | 2 | < 0.1% |
| 5115 | 2 | < 0.1% |
| 6320 | 2 | < 0.1% |
| 2291 | 2 | < 0.1% |
| 3135 | 2 | < 0.1% |
| 11274 | 2 | < 0.1% |
| 2127 | 2 | < 0.1% |
| Other values (4774) | 4837 | |
| (Missing) | 23 | 0.5% |
| Value | Count | Frequency (%) |
| -13244 | 1 | |
| -12688 | 1 | |
| -12629 | 1 | |
| -12459 | 1 | |
| -12086 | 1 | |
| -11785 | 1 | |
| -11577 | 1 | |
| -9660 | 1 | |
| -8617 | 1 | |
| -8446 | 1 |
| Value | Count | Frequency (%) |
| 424791 | 1 | |
| 348703 | 1 | |
| 348296 | 1 | |
| 283001 | 1 | |
| 267146 | 1 | |
| 266840 | 1 | |
| 265325 | 1 | |
| 264810 | 1 | |
| 261330 | 1 | |
| 256515 | 1 |
teq
Real number (ℝ)
| Distinct | 4782 |
|---|---|
| Distinct (%) | 98.4% |
| Missing | 23 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13782.31 |
| Minimum | -11476 |
|---|---|
| Maximum | 428563 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 162 |
| Negative (%) | 3.3% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | -11476 |
|---|---|
| 5-th percentile | 238.8368 |
| Q1 | 2001 |
| median | 5215.5 |
| Q3 | 12187 |
| 95-th percentile | 54004.8 |
| Maximum | 428563 |
| Range | 440039 |
| Interquartile range (IQR) | 10186 |
Descriptive statistics
| Standard deviation | 29886.996 |
|---|---|
| Coefficient of variation (CV) | 2.1685041 |
| Kurtosis | 40.550356 |
| Mean | 13782.31 |
| Median Absolute Deviation (MAD) | 3869.331 |
| Skewness | 5.5943057 |
| Sum | 66968245 |
| Variance | 8.9323256 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8063 | 3 | 0.1% |
| 11296 | 2 | < 0.1% |
| 2622.9 | 2 | < 0.1% |
| 4714 | 2 | < 0.1% |
| 7088 | 2 | < 0.1% |
| 7235 | 2 | < 0.1% |
| 2075 | 2 | < 0.1% |
| 2541 | 2 | < 0.1% |
| 243 | 2 | < 0.1% |
| 7679 | 2 | < 0.1% |
| Other values (4772) | 4838 | |
| (Missing) | 23 | 0.5% |
| Value | Count | Frequency (%) |
| -11476 | 1 | |
| -11203 | 1 | |
| -10900 | 1 | |
| -10739 | 1 | |
| -10653 | 1 | |
| -10230 | 1 | |
| -9599 | 1 | |
| -8446 | 1 | |
| -8341 | 1 | |
| -8300 | 1 |
| Value | Count | Frequency (%) |
| 428563 | 1 | |
| 352500 | 1 | |
| 351954 | 1 | |
| 286359 | 1 | |
| 267146 | 1 | |
| 266840 | 1 | |
| 265325 | 1 | |
| 264810 | 1 | |
| 261330 | 1 | |
| 258627 | 1 |
xad
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 1524 |
|---|---|
| Distinct (%) | 70.5% |
| Missing | 2720 |
| Missing (%) | 55.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 571.4789 |
| Minimum | 0 |
|---|---|
| Maximum | 11000 |
| Zeros | 7 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.205 |
| Q1 | 37.2 |
| median | 153 |
| Q3 | 522.61975 |
| 95-th percentile | 2799.9 |
| Maximum | 11000 |
| Range | 11000 |
| Interquartile range (IQR) | 485.41975 |
Descriptive statistics
| Standard deviation | 1115.1669 |
|---|---|
| Coefficient of variation (CV) | 1.9513701 |
| Kurtosis | 20.370478 |
| Mean | 571.4789 |
| Median Absolute Deviation (MAD) | 140.2 |
| Skewness | 3.9220123 |
| Sum | 1235537.4 |
| Variance | 1243597.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2600 | 10 | 0.2% |
| 2500 | 10 | 0.2% |
| 1200 | 10 | 0.2% |
| 1600 | 9 | 0.2% |
| 30 | 8 | 0.2% |
| 2400 | 8 | 0.2% |
| 98 | 8 | 0.2% |
| 11 | 7 | 0.1% |
| 1000 | 7 | 0.1% |
| 1100 | 7 | 0.1% |
| Other values (1514) | 2078 | |
| (Missing) | 2720 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 0.1 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.3 | 2 | < 0.1% |
| 0.4 | 2 | < 0.1% |
| 0.5 | 2 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.8 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 1.1 | 3 |
| Value | Count | Frequency (%) |
| 11000 | 1 | |
| 9729 | 1 | |
| 9345 | 1 | |
| 9315 | 1 | |
| 9236 | 1 | |
| 8576 | 1 | |
| 8290 | 1 | |
| 8200 | 1 | |
| 7617 | 1 | |
| 7243 | 1 |
xrd
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 1919 |
|---|---|
| Distinct (%) | 67.8% |
| Missing | 2053 |
| Missing (%) | 42.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 888.34346 |
| Minimum | 0 |
|---|---|
| Maximum | 35931 |
| Zeros | 651 |
| Zeros (%) | 13.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 16.476 |
| median | 148.258 |
| Q3 | 651 |
| 95-th percentile | 5151 |
| Maximum | 35931 |
| Range | 35931 |
| Interquartile range (IQR) | 634.524 |
Descriptive statistics
| Standard deviation | 2250.3446 |
|---|---|
| Coefficient of variation (CV) | 2.5331921 |
| Kurtosis | 49.796168 |
| Mean | 888.34346 |
| Median Absolute Deviation (MAD) | 148.258 |
| Skewness | 5.7194273 |
| Sum | 2513123.7 |
| Variance | 5064050.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 651 | 13.3% |
| 1200 | 5 | 0.1% |
| 24 | 5 | 0.1% |
| 376 | 5 | 0.1% |
| 96 | 5 | 0.1% |
| 56 | 5 | 0.1% |
| 647 | 4 | 0.1% |
| 1300 | 4 | 0.1% |
| 93 | 4 | 0.1% |
| 33 | 4 | 0.1% |
| Other values (1909) | 2137 | |
| (Missing) | 2053 |
| Value | Count | Frequency (%) |
| 0 | 651 | |
| 0.153 | 1 | < 0.1% |
| 1.109 | 1 | < 0.1% |
| 1.582 | 1 | < 0.1% |
| 1.632 | 1 | < 0.1% |
| 2.146 | 1 | < 0.1% |
| 3.198 | 1 | < 0.1% |
| 3.3 | 1 | < 0.1% |
| 3.955 | 1 | < 0.1% |
| 4.325 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35931 | 1 | |
| 28837 | 1 | |
| 26018 | 1 | |
| 22620 | 1 | |
| 21419 | 1 | |
| 16876 | 1 | |
| 16625 | 1 | |
| 16217 | 1 | |
| 16085 | 1 | |
| 14726 | 1 |
cik
Real number (ℝ)
| Distinct | 498 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 767463.36 |
| Minimum | 1800 |
|---|---|
| Maximum | 1932393 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 1800 |
|---|---|
| 5-th percentile | 16741.3 |
| Q1 | 96021 |
| median | 878927 |
| Q3 | 1120193 |
| 95-th percentile | 1613103 |
| Maximum | 1932393 |
| Range | 1930593 |
| Interquartile range (IQR) | 1024172 |
Descriptive statistics
| Standard deviation | 539146.57 |
|---|---|
| Coefficient of variation (CV) | 0.70250464 |
| Kurtosis | -1.1918842 |
| Mean | 767463.36 |
| Median Absolute Deviation (MAD) | 445477 |
| Skewness | -0.10135904 |
| Sum | 3.7467561 × 109 |
| Variance | 2.9067903 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 56873 | 11 | 0.2% |
| 104169 | 11 | 0.2% |
| 27419 | 11 | 0.2% |
| 1123360 | 11 | 0.2% |
| 745732 | 11 | 0.2% |
| 1108524 | 11 | 0.2% |
| 1285785 | 11 | 0.2% |
| 1336920 | 11 | 0.2% |
| 1045810 | 11 | 0.2% |
| 764478 | 11 | 0.2% |
| Other values (488) | 4772 |
| Value | Count | Frequency (%) |
| 1800 | 10 | |
| 2488 | 10 | |
| 2969 | 10 | |
| 4127 | 10 | |
| 4281 | 5 | |
| 4447 | 10 | |
| 4904 | 10 | |
| 4962 | 10 | |
| 4977 | 10 | |
| 5272 | 10 |
| Value | Count | Frequency (%) |
| 1932393 | 1 | < 0.1% |
| 1841666 | 10 | |
| 1821825 | 1 | < 0.1% |
| 1792044 | 10 | |
| 1783180 | 5 | |
| 1781335 | 5 | |
| 1757898 | 10 | |
| 1755672 | 5 | |
| 1754301 | 6 | |
| 1751788 | 5 |
costat
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.3 KiB |
| A |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4882 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 4882 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 4882 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 4882 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4882 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4882 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4882 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 4882 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4882 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 4882 |
dvpsp_f
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 848 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 93 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2480741 |
| Minimum | 0 |
|---|---|
| Maximum | 46 |
| Zeros | 1110 |
| Zeros (%) | 22.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.08 |
| median | 0.9 |
| Q3 | 1.8 |
| 95-th percentile | 3.6 |
| Maximum | 46 |
| Range | 46 |
| Interquartile range (IQR) | 1.72 |
Descriptive statistics
| Standard deviation | 1.7444404 |
|---|---|
| Coefficient of variation (CV) | 1.3977058 |
| Kurtosis | 157.23123 |
| Mean | 1.2480741 |
| Median Absolute Deviation (MAD) | 0.84 |
| Skewness | 8.6279011 |
| Sum | 5977.0268 |
| Variance | 3.0430724 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1110 | 22.7% |
| 1 | 57 | 1.2% |
| 0.6 | 53 | 1.1% |
| 0.2 | 51 | 1.0% |
| 0.4 | 48 | 1.0% |
| 0.8 | 44 | 0.9% |
| 2 | 39 | 0.8% |
| 1.6 | 39 | 0.8% |
| 0.72 | 37 | 0.8% |
| 0.04 | 36 | 0.7% |
| Other values (838) | 3275 | |
| (Missing) | 93 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 1110 | |
| 0.018 | 2 | < 0.1% |
| 0.029 | 1 | < 0.1% |
| 0.03 | 2 | < 0.1% |
| 0.04 | 36 | 0.7% |
| 0.0425 | 1 | < 0.1% |
| 0.0433 | 1 | < 0.1% |
| 0.06 | 13 | 0.3% |
| 0.07 | 1 | < 0.1% |
| 0.075 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 46 | 1 | |
| 34.85 | 1 | |
| 30 | 1 | |
| 26.6134 | 1 | |
| 25 | 1 | |
| 18.5 | 1 | |
| 17.7051 | 1 | |
| 14.92 | 1 | |
| 13.2 | 1 | |
| 13.0638 | 1 |
mkvalt
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 4478 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 401 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37117.961 |
| Minimum | 62.8917 |
|---|---|
| Maximum | 1073390.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 62.8917 |
|---|---|
| 5-th percentile | 3291.9376 |
| Q1 | 8341.6526 |
| median | 15763.961 |
| Q3 | 33633.639 |
| 95-th percentile | 151974.21 |
| Maximum | 1073390.5 |
| Range | 1073327.6 |
| Interquartile range (IQR) | 25291.986 |
Descriptive statistics
| Standard deviation | 70851.297 |
|---|---|
| Coefficient of variation (CV) | 1.9088144 |
| Kurtosis | 58.258834 |
| Mean | 37117.961 |
| Median Absolute Deviation (MAD) | 9371.0484 |
| Skewness | 6.2412538 |
| Sum | 1.6632558 × 108 |
| Variance | 5.0199062 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36812.696 | 2 | < 0.1% |
| 19664.7 | 2 | < 0.1% |
| 25119.22 | 2 | < 0.1% |
| 23357.3515 | 1 | < 0.1% |
| 29372.9636 | 1 | < 0.1% |
| 28619.1045 | 1 | < 0.1% |
| 35080.2063 | 1 | < 0.1% |
| 19144.2318 | 1 | < 0.1% |
| 52819.7318 | 1 | < 0.1% |
| 16902.5553 | 1 | < 0.1% |
| Other values (4468) | 4468 | |
| (Missing) | 401 | 8.2% |
| Value | Count | Frequency (%) |
| 62.8917 | 1 | |
| 117.3438 | 1 | |
| 149.1244 | 1 | |
| 160.8317 | 1 | |
| 188.0294 | 1 | |
| 207.0527 | 1 | |
| 266.5571 | 1 | |
| 267.0598 | 1 | |
| 506.2756 | 1 | |
| 509.7578 | 1 |
| Value | Count | Frequency (%) |
| 1073390.54 | 1 | |
| 1023856.28 | 1 | |
| 995151.5669 | 1 | |
| 921138.3192 | 1 | |
| 920224.32 | 1 | |
| 790050.0981 | 1 | |
| 757028.97 | 1 | |
| 737467.27 | 1 | |
| 729439.0252 | 1 | |
| 723558.7085 | 1 |
prcc_f
Real number (ℝ)
| Distinct | 4077 |
|---|---|
| Distinct (%) | 85.4% |
| Missing | 106 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.483715 |
| Minimum | 0.35 |
|---|---|
| Maximum | 3808.41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 0.35 |
|---|---|
| 5-th percentile | 17.62 |
| Q1 | 37.85 |
| median | 61.205 |
| Q3 | 96.2375 |
| 95-th percentile | 226.5575 |
| Maximum | 3808.41 |
| Range | 3808.06 |
| Interquartile range (IQR) | 58.3875 |
Descriptive statistics
| Standard deviation | 141.99435 |
|---|---|
| Coefficient of variation (CV) | 1.5868177 |
| Kurtosis | 222.33198 |
| Mean | 89.483715 |
| Median Absolute Deviation (MAD) | 26.83 |
| Skewness | 11.871569 |
| Sum | 427374.22 |
| Variance | 20162.394 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 72.09 | 4 | 0.1% |
| 36.11 | 4 | 0.1% |
| 56.43 | 4 | 0.1% |
| 19.54 | 4 | 0.1% |
| 58.48 | 4 | 0.1% |
| 68.56 | 4 | 0.1% |
| 41.31 | 4 | 0.1% |
| 76.61 | 4 | 0.1% |
| 35.3 | 4 | 0.1% |
| 37.74 | 4 | 0.1% |
| Other values (4067) | 4736 | |
| (Missing) | 106 | 2.2% |
| Value | Count | Frequency (%) |
| 0.35 | 1 | |
| 0.795 | 1 | |
| 1.01 | 1 | |
| 2.4 | 1 | |
| 2.41 | 1 | |
| 2.67 | 1 | |
| 2.87 | 1 | |
| 3.51 | 1 | |
| 3.65 | 1 | |
| 3.87 | 1 |
| Value | Count | Frequency (%) |
| 3808.41 | 1 | |
| 3508.22 | 1 | |
| 2436.99 | 1 | |
| 2053.73 | 1 | |
| 1847.84 | 1 | |
| 1737.74 | 1 | |
| 1722.42 | 1 | |
| 1669 | 1 | |
| 1643 | 1 | |
| 1501.97 | 1 |
gsector
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34.353748 |
| Minimum | 10 |
|---|---|
| Maximum | 60 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 20 |
| median | 35 |
| Q3 | 45 |
| 95-th percentile | 60 |
| Maximum | 60 |
| Range | 50 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 13.587538 |
|---|---|
| Coefficient of variation (CV) | 0.39551836 |
| Kurtosis | -0.87781663 |
| Mean | 34.353748 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.09908931 |
| Sum | 167715 |
| Variance | 184.6212 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40 | 734 | |
| 20 | 724 | |
| 45 | 622 | |
| 35 | 613 | |
| 25 | 529 | |
| 30 | 363 | |
| 55 | 290 | 5.9% |
| 60 | 289 | 5.9% |
| 15 | 281 | 5.8% |
| 10 | 226 | 4.6% |
| Value | Count | Frequency (%) |
| 10 | 226 | 4.6% |
| 15 | 281 | 5.8% |
| 20 | 724 | |
| 25 | 529 | |
| 30 | 363 | |
| 35 | 613 | |
| 40 | 734 | |
| 45 | 622 | |
| 50 | 211 | 4.3% |
| 55 | 290 | 5.9% |
| Value | Count | Frequency (%) |
| 60 | 289 | 5.9% |
| 55 | 290 | 5.9% |
| 50 | 211 | 4.3% |
| 45 | 622 | |
| 40 | 734 | |
| 35 | 613 | |
| 30 | 363 | |
| 25 | 529 | |
| 20 | 724 | |
| 15 | 281 | 5.8% |
naics
Real number (ℝ)
| Distinct | 206 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 385438.06 |
| Minimum | 42 |
|---|---|
| Maximum | 999977 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 38.3 KiB |
Quantile statistics
| Minimum | 42 |
|---|---|
| 5-th percentile | 2211 |
| Q1 | 325412 |
| median | 339113 |
| Q3 | 522210 |
| 95-th percentile | 561710 |
| Maximum | 999977 |
| Range | 999935 |
| Interquartile range (IQR) | 196798 |
Descriptive statistics
| Standard deviation | 177729.88 |
|---|---|
| Coefficient of variation (CV) | 0.46111141 |
| Kurtosis | 0.52549435 |
| Mean | 385438.06 |
| Median Absolute Deviation (MAD) | 172097 |
| Skewness | -0.56581976 |
| Sum | 1.8817086 × 109 |
| Variance | 3.1587912 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 522110 | 188 | 3.9% |
| 334413 | 168 | 3.4% |
| 531120 | 153 | 3.1% |
| 22111 | 140 | 2.9% |
| 2211 | 120 | 2.5% |
| 524126 | 110 | 2.3% |
| 325412 | 109 | 2.2% |
| 2111 | 100 | 2.0% |
| 518210 | 96 | 2.0% |
| 531110 | 86 | 1.8% |
| Other values (196) | 3612 |
| Value | Count | Frequency (%) |
| 42 | 10 | 0.2% |
| 111 | 5 | 0.1% |
| 315 | 19 | 0.4% |
| 321 | 10 | 0.2% |
| 325 | 10 | 0.2% |
| 423 | 10 | 0.2% |
| 621 | 10 | 0.2% |
| 2111 | 100 | |
| 2211 | 120 | |
| 3113 | 10 | 0.2% |
| Value | Count | Frequency (%) |
| 999977 | 20 | |
| 812331 | 10 | 0.2% |
| 722513 | 40 | |
| 722511 | 20 | |
| 721120 | 30 | |
| 721110 | 20 | |
| 713210 | 6 | 0.1% |
| 711320 | 10 | 0.2% |
| 622110 | 20 | |
| 621511 | 20 |
| gvkey | fyear | fyr | act | at | bkvlps | capx | ceql | csho | dltt | dt | dvp | ebitda | emp | lct | lt | ni | ppegt | pstkl | revt | seq | teq | xad | xrd | cik | dvpsp_f | mkvalt | prcc_f | gsector | naics | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| gvkey | 1.000 | 0.015 | 0.085 | -0.287 | -0.315 | -0.055 | -0.298 | -0.281 | -0.335 | -0.290 | -0.252 | -0.055 | -0.342 | -0.322 | -0.329 | -0.313 | -0.284 | -0.379 | -0.064 | -0.347 | -0.281 | -0.277 | -0.312 | -0.226 | 0.666 | -0.254 | -0.263 | 0.084 | 0.112 | 0.250 |
| fyear | 0.015 | 1.000 | 0.064 | 0.121 | 0.156 | 0.129 | 0.098 | 0.118 | 0.052 | 0.211 | 0.222 | 0.018 | 0.156 | 0.067 | 0.158 | 0.160 | 0.142 | 0.112 | 0.014 | 0.114 | 0.118 | 0.119 | 0.103 | 0.074 | 0.027 | 0.212 | 0.290 | 0.360 | 0.000 | -0.000 |
| fyr | 0.085 | 0.064 | 1.000 | -0.064 | 0.136 | 0.174 | -0.023 | 0.080 | -0.028 | 0.177 | 0.133 | 0.171 | 0.046 | -0.148 | -0.006 | 0.149 | -0.022 | 0.067 | 0.144 | -0.058 | 0.084 | 0.091 | -0.064 | -0.000 | 0.034 | 0.028 | -0.004 | 0.031 | 0.015 | 0.060 |
| act | -0.287 | 0.121 | -0.064 | 1.000 | 0.826 | 0.196 | 0.613 | 0.712 | 0.739 | 0.599 | 0.645 | 0.067 | 0.814 | 0.662 | 0.900 | 0.787 | 0.707 | 0.589 | 0.060 | 0.860 | 0.711 | 0.711 | 0.654 | 0.525 | -0.178 | 0.340 | 0.762 | 0.085 | -0.014 | -0.102 |
| at | -0.315 | 0.156 | 0.136 | 0.826 | 1.000 | 0.396 | 0.567 | 0.869 | 0.748 | 0.837 | 0.840 | 0.327 | 0.881 | 0.536 | 0.903 | 0.975 | 0.695 | 0.779 | 0.301 | 0.784 | 0.870 | 0.875 | 0.621 | 0.401 | -0.174 | 0.363 | 0.742 | 0.003 | 0.078 | -0.008 |
| bkvlps | -0.055 | 0.129 | 0.174 | 0.196 | 0.396 | 1.000 | 0.103 | 0.561 | -0.107 | 0.219 | 0.186 | 0.181 | 0.264 | 0.040 | 0.196 | 0.313 | 0.233 | 0.227 | 0.166 | 0.186 | 0.561 | 0.554 | 0.098 | 0.003 | -0.006 | 0.255 | 0.175 | 0.430 | 0.035 | -0.013 |
| capx | -0.298 | 0.098 | -0.023 | 0.613 | 0.567 | 0.103 | 1.000 | 0.507 | 0.552 | 0.577 | 0.596 | -0.054 | 0.713 | 0.562 | 0.716 | 0.551 | 0.479 | 0.954 | -0.048 | 0.682 | 0.502 | 0.511 | 0.617 | 0.438 | -0.107 | 0.208 | 0.580 | 0.025 | -0.215 | -0.377 |
| ceql | -0.281 | 0.118 | 0.080 | 0.712 | 0.869 | 0.561 | 0.507 | 1.000 | 0.706 | 0.656 | 0.626 | 0.282 | 0.792 | 0.441 | 0.708 | 0.763 | 0.663 | 0.659 | 0.261 | 0.680 | 0.999 | 0.996 | 0.543 | 0.424 | -0.152 | 0.296 | 0.707 | 0.006 | 0.080 | -0.076 |
| csho | -0.335 | 0.052 | -0.028 | 0.739 | 0.748 | -0.107 | 0.552 | 0.706 | 1.000 | 0.659 | 0.651 | 0.198 | 0.787 | 0.547 | 0.742 | 0.701 | 0.637 | 0.661 | 0.174 | 0.716 | 0.705 | 0.709 | 0.617 | 0.493 | -0.209 | 0.174 | 0.732 | -0.321 | 0.050 | -0.098 |
| dltt | -0.290 | 0.211 | 0.177 | 0.599 | 0.837 | 0.219 | 0.577 | 0.656 | 0.659 | 1.000 | 0.997 | 0.291 | 0.806 | 0.480 | 0.723 | 0.869 | 0.558 | 0.783 | 0.261 | 0.678 | 0.656 | 0.667 | 0.565 | 0.205 | -0.142 | 0.391 | 0.659 | 0.003 | 0.061 | -0.056 |
| dt | -0.252 | 0.222 | 0.133 | 0.645 | 0.840 | 0.186 | 0.596 | 0.626 | 0.651 | 0.997 | 1.000 | 0.221 | 0.798 | 0.514 | 0.738 | 0.880 | 0.554 | 0.768 | 0.170 | 0.691 | 0.626 | 0.635 | 0.573 | 0.215 | -0.137 | 0.374 | 0.676 | 0.046 | -0.036 | -0.005 |
| dvp | -0.055 | 0.018 | 0.171 | 0.067 | 0.327 | 0.181 | -0.054 | 0.282 | 0.198 | 0.291 | 0.221 | 1.000 | 0.242 | -0.037 | 0.126 | 0.318 | 0.117 | 0.224 | 0.845 | 0.042 | 0.300 | 0.301 | 0.117 | -0.140 | -0.048 | 0.142 | 0.120 | -0.105 | 0.270 | 0.155 |
| ebitda | -0.342 | 0.156 | 0.046 | 0.814 | 0.881 | 0.264 | 0.713 | 0.792 | 0.787 | 0.806 | 0.798 | 0.242 | 1.000 | 0.678 | 0.854 | 0.849 | 0.840 | 0.796 | 0.221 | 0.883 | 0.792 | 0.794 | 0.708 | 0.428 | -0.200 | 0.449 | 0.858 | 0.117 | -0.003 | -0.062 |
| emp | -0.322 | 0.067 | -0.148 | 0.662 | 0.536 | 0.040 | 0.562 | 0.441 | 0.547 | 0.480 | 0.514 | -0.037 | 0.678 | 1.000 | 0.688 | 0.549 | 0.584 | 0.562 | -0.035 | 0.817 | 0.435 | 0.431 | 0.643 | 0.286 | -0.225 | 0.175 | 0.579 | 0.051 | -0.254 | 0.012 |
| lct | -0.329 | 0.158 | -0.006 | 0.900 | 0.903 | 0.196 | 0.716 | 0.708 | 0.742 | 0.723 | 0.738 | 0.126 | 0.854 | 0.688 | 1.000 | 0.911 | 0.693 | 0.702 | 0.106 | 0.889 | 0.707 | 0.712 | 0.710 | 0.431 | -0.179 | 0.411 | 0.758 | 0.069 | 0.013 | -0.074 |
| lt | -0.313 | 0.160 | 0.149 | 0.787 | 0.975 | 0.313 | 0.551 | 0.763 | 0.701 | 0.869 | 0.880 | 0.318 | 0.849 | 0.549 | 0.911 | 1.000 | 0.654 | 0.765 | 0.291 | 0.772 | 0.763 | 0.770 | 0.606 | 0.351 | -0.177 | 0.368 | 0.696 | 0.003 | 0.064 | 0.018 |
| ni | -0.284 | 0.142 | -0.022 | 0.707 | 0.695 | 0.233 | 0.479 | 0.663 | 0.637 | 0.558 | 0.554 | 0.117 | 0.840 | 0.584 | 0.693 | 0.654 | 1.000 | 0.548 | 0.106 | 0.735 | 0.661 | 0.653 | 0.618 | 0.373 | -0.197 | 0.371 | 0.786 | 0.210 | -0.044 | -0.037 |
| ppegt | -0.379 | 0.112 | 0.067 | 0.589 | 0.779 | 0.227 | 0.954 | 0.659 | 0.661 | 0.783 | 0.768 | 0.224 | 0.796 | 0.562 | 0.702 | 0.765 | 0.548 | 1.000 | 0.202 | 0.742 | 0.660 | 0.672 | 0.669 | 0.307 | -0.192 | 0.419 | 0.626 | -0.016 | -0.111 | -0.314 |
| pstkl | -0.064 | 0.014 | 0.144 | 0.060 | 0.301 | 0.166 | -0.048 | 0.261 | 0.174 | 0.261 | 0.170 | 0.845 | 0.221 | -0.035 | 0.106 | 0.291 | 0.106 | 0.202 | 1.000 | 0.028 | 0.280 | 0.280 | 0.115 | -0.126 | -0.055 | 0.153 | 0.115 | -0.100 | 0.309 | 0.115 |
| revt | -0.347 | 0.114 | -0.058 | 0.860 | 0.784 | 0.186 | 0.682 | 0.680 | 0.716 | 0.678 | 0.691 | 0.042 | 0.883 | 0.817 | 0.889 | 0.772 | 0.735 | 0.742 | 0.028 | 1.000 | 0.675 | 0.678 | 0.753 | 0.374 | -0.212 | 0.304 | 0.746 | 0.049 | -0.200 | -0.141 |
| seq | -0.281 | 0.118 | 0.084 | 0.711 | 0.870 | 0.561 | 0.502 | 0.999 | 0.705 | 0.656 | 0.626 | 0.300 | 0.792 | 0.435 | 0.707 | 0.763 | 0.661 | 0.660 | 0.280 | 0.675 | 1.000 | 0.997 | 0.540 | 0.418 | -0.150 | 0.299 | 0.704 | 0.005 | 0.087 | -0.070 |
| teq | -0.277 | 0.119 | 0.091 | 0.711 | 0.875 | 0.554 | 0.511 | 0.996 | 0.709 | 0.667 | 0.635 | 0.301 | 0.794 | 0.431 | 0.712 | 0.770 | 0.653 | 0.672 | 0.280 | 0.678 | 0.997 | 1.000 | 0.544 | 0.414 | -0.145 | 0.302 | 0.702 | -0.002 | 0.080 | -0.072 |
| xad | -0.312 | 0.103 | -0.064 | 0.654 | 0.621 | 0.098 | 0.617 | 0.543 | 0.617 | 0.565 | 0.573 | 0.117 | 0.708 | 0.643 | 0.710 | 0.606 | 0.618 | 0.669 | 0.115 | 0.753 | 0.540 | 0.544 | 1.000 | 0.324 | -0.229 | 0.337 | 0.682 | 0.078 | 0.009 | -0.133 |
| xrd | -0.226 | 0.074 | -0.000 | 0.525 | 0.401 | 0.003 | 0.438 | 0.424 | 0.493 | 0.205 | 0.215 | -0.140 | 0.428 | 0.286 | 0.431 | 0.351 | 0.373 | 0.307 | -0.126 | 0.374 | 0.418 | 0.414 | 0.324 | 1.000 | -0.141 | -0.011 | 0.494 | -0.015 | 0.048 | -0.343 |
| cik | 0.666 | 0.027 | 0.034 | -0.178 | -0.174 | -0.006 | -0.107 | -0.152 | -0.209 | -0.142 | -0.137 | -0.048 | -0.200 | -0.225 | -0.179 | -0.177 | -0.197 | -0.192 | -0.055 | -0.212 | -0.150 | -0.145 | -0.229 | -0.141 | 1.000 | -0.219 | -0.166 | 0.041 | 0.074 | 0.124 |
| dvpsp_f | -0.254 | 0.212 | 0.028 | 0.340 | 0.363 | 0.255 | 0.208 | 0.296 | 0.174 | 0.391 | 0.374 | 0.142 | 0.449 | 0.175 | 0.411 | 0.368 | 0.371 | 0.419 | 0.153 | 0.304 | 0.299 | 0.302 | 0.337 | -0.011 | -0.219 | 1.000 | 0.385 | 0.324 | -0.029 | -0.097 |
| mkvalt | -0.263 | 0.290 | -0.004 | 0.762 | 0.742 | 0.175 | 0.580 | 0.707 | 0.732 | 0.659 | 0.676 | 0.120 | 0.858 | 0.579 | 0.758 | 0.696 | 0.786 | 0.626 | 0.115 | 0.746 | 0.704 | 0.702 | 0.682 | 0.494 | -0.166 | 0.385 | 1.000 | 0.333 | -0.024 | -0.052 |
| prcc_f | 0.084 | 0.360 | 0.031 | 0.085 | 0.003 | 0.430 | 0.025 | 0.006 | -0.321 | 0.003 | 0.046 | -0.105 | 0.117 | 0.051 | 0.069 | 0.003 | 0.210 | -0.016 | -0.100 | 0.049 | 0.005 | -0.002 | 0.078 | -0.015 | 0.041 | 0.324 | 0.333 | 1.000 | -0.103 | 0.068 |
| gsector | 0.112 | 0.000 | 0.015 | -0.014 | 0.078 | 0.035 | -0.215 | 0.080 | 0.050 | 0.061 | -0.036 | 0.270 | -0.003 | -0.254 | 0.013 | 0.064 | -0.044 | -0.111 | 0.309 | -0.200 | 0.087 | 0.080 | 0.009 | 0.048 | 0.074 | -0.029 | -0.024 | -0.103 | 1.000 | 0.277 |
| naics | 0.250 | -0.000 | 0.060 | -0.102 | -0.008 | -0.013 | -0.377 | -0.076 | -0.098 | -0.056 | -0.005 | 0.155 | -0.062 | 0.012 | -0.074 | 0.018 | -0.037 | -0.314 | 0.115 | -0.141 | -0.070 | -0.072 | -0.133 | -0.343 | 0.124 | -0.097 | -0.052 | 0.068 | 0.277 | 1.000 |
| gvkey | datadate | fyear | indfmt | consol | popsrc | datafmt | tic | cusip | conm | curcd | fyr | act | at | bkvlps | capx | ceql | csho | dltt | dt | dvp | ebitda | emp | lct | lt | ni | ppegt | pstkl | revt | seq | teq | xad | xrd | cik | costat | dvpsp_f | mkvalt | prcc_f | gsector | naics | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1045 | 2010-12-31 | 2010 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 6838.0 | 25088.0 | -11.8309 | 1962.0 | -3945.0 | 333.450 | 9253.0 | 11136.0 | 0.0 | 1303.0 | 78.25 | 8780.0 | 29033.0 | -471.0 | 26717.0 | 0.0 | 22170.0 | -3945.0 | -3945.0 | 165.0 | NaN | 6201 | A | 0.0 | 2597.5755 | 7.790 | 20 | 481111 |
| 1 | 1045 | 2011-12-31 | 2011 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 6757.0 | 23848.0 | -21.2099 | 1610.0 | -7111.0 | 335.268 | 6702.0 | 8220.0 | 0.0 | 695.0 | 80.10 | 8630.0 | 30959.0 | -1979.0 | 24854.0 | 0.0 | 24022.0 | -7111.0 | -7111.0 | 186.0 | NaN | 6201 | A | 0.0 | 117.3438 | 0.350 | 20 | 481111 |
| 2 | 1045 | 2012-12-31 | 2012 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 7072.0 | 23510.0 | -23.8210 | 1888.0 | -7987.0 | 335.292 | 7116.0 | 8535.0 | 0.0 | 1434.0 | 77.75 | 9304.0 | 31497.0 | -1876.0 | 24233.0 | 0.0 | 24855.0 | -7987.0 | -7987.0 | 153.0 | NaN | 6201 | A | 0.0 | 266.5571 | 0.795 | 20 | 481111 |
| 3 | 1045 | 2013-12-31 | 2013 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 14323.0 | 42278.0 | -10.4608 | 3114.0 | -2731.0 | 261.069 | 15353.0 | 16799.0 | 0.0 | 2956.0 | 110.40 | 13806.0 | 45009.0 | -1834.0 | 30392.0 | 0.0 | 26712.0 | -2731.0 | -2731.0 | 166.0 | NaN | 6201 | A | 0.0 | 6591.9923 | 25.250 | 20 | 481111 |
| 4 | 1045 | 2014-12-31 | 2014 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 12112.0 | 43771.0 | 2.8976 | 5311.0 | 2021.0 | 697.475 | 16196.0 | 17904.0 | 0.0 | 6585.0 | 113.30 | 13435.0 | 41750.0 | 2882.0 | 35343.0 | 0.0 | 42650.0 | 2021.0 | 2021.0 | 100.0 | NaN | 6201 | A | 0.2 | 37405.5843 | 53.630 | 20 | 481111 |
| 5 | 1045 | 2015-12-31 | 2015 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 9985.0 | 48415.0 | 9.0215 | 6151.0 | 5635.0 | 624.622 | 18330.0 | 20561.0 | 0.0 | 8891.0 | 118.50 | 13605.0 | 42780.0 | 7610.0 | 40654.0 | 0.0 | 40990.0 | 5635.0 | 5635.0 | 110.0 | NaN | 6201 | A | 0.4 | 26452.7417 | 42.350 | 20 | 481111 |
| 6 | 1045 | 2016-12-31 | 2016 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 10324.0 | 51274.0 | 7.4612 | 5731.0 | 3785.0 | 507.294 | 22489.0 | 24344.0 | 0.0 | 7833.0 | 122.30 | 13872.0 | 47489.0 | 2676.0 | 45353.0 | 0.0 | 40180.0 | 3785.0 | 3785.0 | 116.0 | NaN | 6201 | A | 0.4 | 23685.5569 | 46.690 | 20 | 481111 |
| 7 | 1045 | 2017-12-31 | 2017 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 9146.0 | 51396.0 | 8.2564 | 5971.0 | 3926.0 | 475.508 | 22511.0 | 25065.0 | 0.0 | 6809.0 | 126.60 | 14964.0 | 47470.0 | 1919.0 | 49802.0 | 0.0 | 42207.0 | 3926.0 | 3926.0 | 135.0 | NaN | 6201 | A | 0.4 | 24740.6812 | 52.030 | 20 | 481111 |
| 8 | 1045 | 2018-12-31 | 2018 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 8637.0 | 60580.0 | -0.3669 | 3745.0 | -169.0 | 460.611 | 29081.0 | 34029.0 | 0.0 | 5606.0 | 128.90 | 18096.0 | 60749.0 | 1412.0 | 60692.0 | 0.0 | 44541.0 | -169.0 | -169.0 | 128.0 | NaN | 6201 | A | 0.4 | 14790.2192 | 32.110 | 20 | 481111 |
| 9 | 1045 | 2019-12-31 | 2019 | INDL | C | D | STD | AAL | 02376R102 | AMERICAN AIRLINES GROUP INC | USD | 12 | 8206.0 | 59995.0 | -0.2756 | 4268.0 | -118.0 | 428.203 | 28875.0 | 33444.0 | 0.0 | 6024.0 | 133.70 | 18311.0 | 60113.0 | 1686.0 | 62391.0 | 0.0 | 45768.0 | -118.0 | -118.0 | 129.0 | NaN | 6201 | A | 0.4 | 12280.8620 | 28.680 | 20 | 481111 |
| gvkey | datadate | fyear | indfmt | consol | popsrc | datafmt | tic | cusip | conm | curcd | fyr | act | at | bkvlps | capx | ceql | csho | dltt | dt | dvp | ebitda | emp | lct | lt | ni | ppegt | pstkl | revt | seq | teq | xad | xrd | cik | costat | dvpsp_f | mkvalt | prcc_f | gsector | naics | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4872 | 294524 | 2019-12-31 | 2019 | INDL | C | D | STD | LYB | N53745100 | LYONDELLBASELL INDUSTRIES NV | USD | 12 | 9510.0 | 30435.0 | 24.1216 | 2694.0 | 8044.0 | 333.477 | 12830.0 | 13106.0 | 0.0 | 5544.0 | 19.1 | 5198.0 | 22256.0 | 3390.0 | 22728.0 | 0.0 | 34727.0 | 8044.0 | 8063.0 | NaN | 111.0 | 1489393 | A | 4.15 | 31506.9070 | 94.48 | 15 | 325220 |
| 4873 | 316056 | 2011-12-31 | 2011 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 961.7 | 2036.2 | NaN | 25.5 | 1413.8 | NaN | 3.5 | 4.9 | 0.0 | 405.3 | NaN | 374.5 | 600.4 | 218.1 | 558.0 | 0.0 | 2021.2 | 1413.8 | 1435.8 | NaN | 38.9 | 1579241 | A | NaN | NaN | NaN | 20 | 332510 |
| 4874 | 316056 | 2012-12-31 | 2012 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 909.9 | 1983.8 | NaN | 19.6 | 1343.2 | NaN | 2.8 | 3.7 | 0.0 | 419.9 | 7.6 | 382.7 | 617.6 | 219.6 | 586.8 | 0.0 | 2046.6 | 1343.2 | 1366.2 | NaN | 38.2 | 1579241 | A | NaN | NaN | NaN | 20 | 332510 |
| 4875 | 316056 | 2013-12-31 | 2013 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 923.2 | 1979.9 | -0.9039 | 20.2 | -86.8 | 96.029 | 1272.0 | 1302.0 | 0.0 | 409.0 | 8.0 | 490.5 | 2035.6 | 31.0 | 569.2 | 0.0 | 2093.5 | -86.8 | -55.7 | NaN | 39.6 | 1579241 | A | 0.00 | 4243.5215 | 44.19 | 20 | 332510 |
| 4876 | 316056 | 2014-12-31 | 2014 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 973.8 | 2015.9 | -0.0501 | 51.5 | -4.8 | 95.831 | 1215.0 | 1215.0 | 0.0 | 439.3 | 8.5 | 531.3 | 1997.4 | 175.2 | 586.8 | 0.0 | 2118.3 | -4.8 | 18.5 | NaN | 43.3 | 1579241 | A | 0.32 | 5314.7873 | 55.46 | 20 | 332510 |
| 4877 | 316056 | 2015-12-31 | 2015 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 735.1 | 2285.3 | 0.2667 | 35.2 | 25.6 | 95.991 | 1479.8 | 1479.8 | 0.0 | 444.1 | 9.4 | 447.1 | 2255.6 | 153.9 | 616.5 | 0.0 | 2068.1 | 25.6 | 29.7 | NaN | 45.2 | 1579241 | A | 0.40 | 6327.7267 | 65.92 | 20 | 332510 |
| 4878 | 316056 | 2016-12-31 | 2016 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 829.3 | 2247.4 | 1.1892 | 42.5 | 113.3 | 95.274 | 1415.6 | 1463.8 | 0.0 | 490.0 | 9.4 | 429.6 | 2131.0 | 229.1 | 640.4 | 0.0 | 2238.0 | 113.3 | 116.4 | NaN | 47.3 | 1579241 | A | 0.48 | 6097.5360 | 64.00 | 20 | 332510 |
| 4879 | 316056 | 2017-12-31 | 2017 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 1032.7 | 2542.0 | 4.2246 | 49.3 | 401.6 | 95.062 | 1442.3 | 1477.3 | 0.0 | 567.3 | 10.0 | 460.8 | 2136.5 | 273.3 | 707.9 | 0.0 | 2408.2 | 401.6 | 405.5 | NaN | 48.3 | 1579241 | A | 0.64 | 7563.1327 | 79.56 | 20 | 332510 |
| 4880 | 316056 | 2018-12-31 | 2018 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 931.6 | 2810.2 | 6.8789 | 49.1 | 651.0 | 94.637 | 1409.5 | 1444.8 | 0.0 | 619.0 | 11.0 | 520.8 | 2156.2 | 434.9 | 748.8 | 0.0 | 2731.7 | 651.0 | 654.0 | NaN | 54.4 | 1579241 | A | 0.84 | 7543.5153 | 79.71 | 20 | 332510 |
| 4881 | 316056 | 2019-12-31 | 2019 | INDL | C | D | STD | ALLE | G0176J109 | ALLEGION PLC | USD | 12 | 1001.8 | 2967.2 | 8.1683 | 65.6 | 757.4 | 92.724 | 1483.2 | 1509.1 | 0.0 | 651.3 | 11.0 | 507.0 | 2206.8 | 401.8 | 867.4 | 0.0 | 2854.0 | 757.4 | 760.4 | NaN | 54.7 | 1579241 | A | 1.08 | 11547.8470 | 124.54 | 20 | 332510 |